SQL error --Logshipping
Posted on 2011-05-09
I set log shipping and it been working great for a few month. However, starting last week I notice that there is an issue and no logs are been applied.
Can I fix this issue or do I have redo the logshipping..
The last log applied is admin_db_201105061211511.trn
SQL Server 2005
The error I get is :
The backup data at the end of "f:\logshipping\qcsiteadmin_db\admin_db_20110506130011.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.