Monday, February 6, 2012

Restore failed for Server - RESTORE HEADERONLY is terminating abnormally

Error Detail..
Very often you will encountered by this error.This will happen due to many reasons.
Before searching for any other solution you must be sure about these things.

1. Backup copy of Database is good.
    -Try to restore the backup in test database in the same server from where  it has been taken.If its restored   successfully then backup copy is good.If you feel backup is corrupted then take a fresh backup.

2. Backup copy doesn't get corrupted during download.
    -Backup may get corrupted during downloading from FTP etc. If you are using FTP then use it in binary mode to copy the backup file into local drive
3. Backup was taken on a higher version of SQL Server and restoration is being done
   on the lower version.
To know your Sql Server version run "Select @@Version" command.

If the versions are different then update the SQL Server of system on which you are trying to restore the backup

No comments:

Post a Comment