Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

Thanks.

share|improve this question

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.