I am getting this error while restoring the backup.

Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205)

I have .bak file, I am using SQL Server 2008 R2.


migrated from stackoverflow.com Jan 6 '12 at 21:27

This question came from our site for professional and enthusiast programmers.

  • 3
    Can you post the restore statement you're using? – Mithrandir Jan 6 '12 at 21:01
  • I have created the db and then right click on that db > tasks > restore > database. – Sami Jan 6 '12 at 21:04
  • While the error does not seem to indicate such, this is commonly seen when trying to restore a backup made on one version of SQL to a server running another version. What version of SQL is this backup from? – David Perry Jan 6 '12 at 21:10
  • 1
    Why did you create an empty (?) database first? Why not just go to the database node in the object explorer > restore database? This might prevent an issue with the database compatibility level. – Mithrandir Jan 6 '12 at 21:11
  • 1
    To @Mithrandir's point: Before you hit "OK" on the restore dialog, hit the "Script" button and show us the restore script it outputs. – Nick Chammas Jan 6 '12 at 21:32

I am sorry to say, but you have a corrupt backup file. If you can, backup the database again, but use the "with verify" option to ensure it is fully functional.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy