April 25, 2009 at 3:25 pm
Guys,
We are running log shipping, during this process one of transaction logs failed to restore on the secondary database to corruption of the log. Below is the message from the sql logs
Message
The backup data at the end of "\v-XXXX\Y$\Database\Backup\XXXXX_20090424150000.trn" is incorrectly formatted. Backup sets on the media might be damaged and unusable. To determine the backup sets on the media, use RESTORE HEADERONLY. To determine the usability of the backup sets, run RESTORE VERIFYONLY. If all of the backup sets are incomplete, reformat the media using BACKUP WITH FORMAT, which destroys all the backup sets.
How can I restore the database to previous true uncorrupted log file so that I can bring back the database from restoring mode. I will stop the automatic restore of log files after I bring back the database from restoring mode.
Any suggestions/inputs would help.
Thanks
April 25, 2009 at 5:34 pm
are you trying to recover the standby database because you want to failover?
what does restore verifyonly of that log file say?
That last log will have failed to restore so database should be at state at end of previous log restore, so you can just run restore database with recovery
If not, take another full backup of the primary to restart the log chain, copy that to the secondary and restore it norecovery, then restart logshipping.
---------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply