Posted by John Rajendran on 09/30/43 11:16

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

[Back to original message]