I tried to complete a SQL server 2005 database Restore from disk,this information message was displayed in the error logs:
The backup data at the end of "K:\backups\mybackup.bak" 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 ran this command:
after 1 hr there were still no response - on a 20 GB database.
As a way of troubleshooting - I issued the BACKUP DATABASE command again, with the the FORMAT option. This time, I issued the RESTORE VERIFYONLY and got a positive response within a short while. I was able to complete the RESTORE.
The important point here was that the initial backup was reported as successfull, in the Logs, but then failed on the RESTORE. This indicates a filemark in the backup device could not be read.With some research the most likely reason for the initial RESTORE failure was that SQL server reported the BACKUP as OK - even though a IO write failed.
Republished from http://www.sqlserver-dba.com.
Republished from SQL Server DBA [65 clicks].
Read the original version here [32134 clicks].