I would like to know in detail about the differences between back up set,
media set, media family, devise etc. Can any one provide link to resourses
where I can find that. In BOL it is bit confusing.
Thanks in Advance
R.DAn image tell more than a thousand words.
Using Media Sets and Families
http://msdn.microsoft.com/library/d... />
t_70oj.asp
AMB
"R.D" wrote:
> Hi All
> I would like to know in detail about the differences between back up set,
> media set, media family, devise etc. Can any one provide link to resourses
> where I can find that. In BOL it is bit confusing.
> Thanks in Advance
> R.D|||> An image tell more than a thousand words.
Keep up with the news. You should soon say:
An varbinary(max) tell more than a thousand words.
<g>
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:4549A302-23DF-4E5C-BBE1-AF1D26E43C17@.microsoft.com...
> An image tell more than a thousand words.
> Using Media Sets and Families
> http://msdn.microsoft.com/library/d...>
rst_70oj.asp
>
> AMB
> "R.D" wrote:
>|||Media Sets and Families
Media sets comprise several individual media. All media in a media set
should be of the same type. For example, a 200-GB database might span 3
tapes. The 3 tapes are considered to be a media set.
A media family refers to the collection of media used by an individual
backup device. For example, if a 2-TB database is backed up using 4 tape
drives (with 5 tapes in each drive), each set of 5 tapes is considered to be
a media family. Collectively the 20 tapes would be considered a media set.
[url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx[
/url]
Aleksandar Grbic
MCDBA, Senior Database Administrator
"R.D" wrote:
> Hi All
> I would like to know in detail about the differences between back up set,
> media set, media family, devise etc. Can any one provide link to resourses
> where I can find that. In BOL it is bit confusing.
> Thanks in Advance
> R.D|||Tibor,
This is good. I am happy to start a new w
with some humor.AMB
"Tibor Karaszi" wrote:
> Keep up with the news. You should soon say:
> An varbinary(max) tell more than a thousand words.
> <g>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in messag
e
> news:4549A302-23DF-4E5C-BBE1-AF1D26E43C17@.microsoft.com...
>
