By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,130 Members | 2,100 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,130 IT Pros & Developers. It's quick & easy.

SQL SERVER BACKUP problem in different DEVICES

P: n/a

Hi there,
I need to take a backup with the following scanerio in mind:
At T1 I take the FULL BACK UP of the database called BACK_1_FULL.BACK in
c:\
Then at T2 I would like to take only the differential BACKUP of the
Transaction log called BACK_1_TRANSLOG.BACK and at T3 I would like to
take
only the differential BACKUP of the Transaction log called
BACK_2_TRANSLOG.BACK. At T4 my system fails and I need to bring the
database
to a point where my T3 state is in. I tried taking the backups in DEVICE
but
I always get an error from SQL Server Enterprise manager such as
Volume on Device 'Device2' is not part of a family media set. BACKUP
WITH NO
FORMAT can be used to form a new media set. BACKUP LOG is terminating
abnormally.

If someone can give suggestions on how to backup and restore in this
situation it will be really helpful.
Thanks
John


*** Sent via Developersdex http://www.developersdex.com ***
Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
John Rajendran (jo************@xiotech.com) writes:
I need to take a backup with the following scanerio in mind:
At T1 I take the FULL BACK UP of the database called BACK_1_FULL.BACK in
c:\
Then at T2 I would like to take only the differential BACKUP of the
Transaction log called BACK_1_TRANSLOG.BACK and at T3 I would like to
take only the differential BACKUP of the Transaction log called
BACK_2_TRANSLOG.BACK.
I don't think there is any real confusion here, but I like to straighten
out the terminology. In SQL Server you have three forms of backup:
1) Full backup
2) Differential backup
3) Transaction-log backup

The first two backs up what is in the data file, where as the last backsup
the transaction log. A translog backup permits you to restore the
database to about any point in time, not necessarily one at which you
took a backup.

Most backup scheme for production schemes includes a full backup and
a translog backup. Differential backups are not equally commonly used.
At T4 my system fails and I need to bring the database to a point where
my T3 state is in. I tried taking the backups in DEVICE but I always get
an error from SQL Server Enterprise manager such as Volume on Device
'Device2' is not part of a family media set. BACKUP WITH NO FORMAT can
be used to form a new media set. BACKUP LOG is terminating abnormally.


I don't know the dialogues in Enterprise Maanger well, as I mainly use SQL
command to backup and restore databases. But it appears as if you are
trying to use backup devices rather than just a plain filename. Backup
devices are mainly for tapes and that.

While using EM may be convenient for a while, you probaby make it
better in the long run, by reading about the BACKUP and RESTORE
commands in Books Online. Once you have scripts developed, you have
something which you can keep canned and easily use in case of a
disaster.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.