November 17, 2008 at 2:54 pm
Lynn
thanks I will try this I need to shift gears I can update tomorrow. let's think ahead though. What if the RESTORE HEADERONLY for the diff backup does NOT match the msdb backupset table?
November 18, 2008 at 2:09 pm
Lynn,
To recap. I backup (full and diff) from Prod then zip, transfer and restore to Warm. As per your suggestion I did the following:
On the Prod server I see the incremental backup on msdb.dbo.backupset. I noted the first_lsn, last_lsn, checkpoint_lsn and database_backup_lsn field values
Then I did a RESTORE HEADERONLY on the zipped and transferred file from prod and verified that the lsn fields on the header matched the prod msdb backupset table.
So now that it matched I tried my script again for one of the 53 databases I have to do this for...and it worked...great! :w00t:
Sort of I really do not know what I have done differently but at least I have the heads up with the backupset table.
November 18, 2008 at 2:48 pm
More info found the problem
In my SQL job I did each database full recovery with NORECOVERY option
then I did a seperate step for the Differential restore.
SQL Job Agent or something causes the error
If I combine the ALTER DATABASE, RESTORE full then RESTORE diff in one step I am able to restore my differential backup
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply