Media set

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.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...
>

Media Family ... Is Incorrectly Formed

I am using SQL Server 2000 SP 3a enterprise. We do a nightly backup to
a
network location and then in the middle of the night the files are
written to
tape from the network. We have verified our backup plan will work by
choosing a backup and restoring it to the database. We have done this
many
times without problems. However, there is a backup that when I try to
restore it I get the Error:
Server: Msg 3241, Level 16, State 37, Line 1 The media family on device
'UNC
Path.bak' is incorrectly formed. SQL Server cannot process this media
family.
I have run the command: RESTORE HEADERONLY FROM DISK='UNC Path.BAK'.
The
backupName from this says *** INCOMPLETE ***; Position = 1; the rest of
the
fields are NULL.
What would happen to make the backup INCOMPLETE? Maybe this would
happen if
an error was encountered part way throught backing up the file? The
file has
almost 800 MB of data in it. I would like to restore this file and get
out a
specific set of records if possible. Even if I can't get everything,
if I
could get at least some of it then that would be better than a complete
loss.
Is there anyway to get the data that is contained in the file back?
Thank you
KalvinHi
A bad backup is a bad backup, not much you can do with it. Maybe opening a
call with Microsoft PSS might help as they may have tools to read partial
backups.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kalvin" wrote:

> I am using SQL Server 2000 SP 3a enterprise. We do a nightly backup to
> a
> network location and then in the middle of the night the files are
> written to
> tape from the network. We have verified our backup plan will work by
> choosing a backup and restoring it to the database. We have done this
> many
> times without problems. However, there is a backup that when I try to
> restore it I get the Error:
> Server: Msg 3241, Level 16, State 37, Line 1 The media family on device
> 'UNC
> Path.bak' is incorrectly formed. SQL Server cannot process this media
> family.
> I have run the command: RESTORE HEADERONLY FROM DISK='UNC Path.BAK'.
> The
> backupName from this says *** INCOMPLETE ***; Position = 1; the rest of
> the
> fields are NULL.
> What would happen to make the backup INCOMPLETE? Maybe this would
> happen if
> an error was encountered part way throught backing up the file? The
> file has
> almost 800 MB of data in it. I would like to restore this file and get
> out a
> specific set of records if possible. Even if I can't get everything,
> if I
> could get at least some of it then that would be better than a complete
> loss.
>
> Is there anyway to get the data that is contained in the file back?
>
> --
> Thank you
> Kalvin
>