Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2009-04-25 : 17:24:26
|
| 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 logsMessageThe backup data at the end of "\\nv-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 |
|
|
Stamey
Starting Member
14 Posts |
Posted - 2009-04-27 : 13:28:32
|
| I'd restore the last full backup and then the previous most recent tran log, before the log where the corruption occurred. That should get you to just before the corrupt tran log backup.Chris |
 |
|
|
|
|
|
Database in Restoring State