SiemensSEN
asked on
SQL error --Logshipping
Hello,
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.t rn
SQL Server 2005
The error I get is :
The backup data at the end of "f:\logshipping\qcsiteadmi n_db\admin _db_201105 06130011.t rn" 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.
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.t
SQL Server 2005
The error I get is :
The backup data at the end of "f:\logshipping\qcsiteadmi
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER