Take the 2-minute tour ×
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.

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
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
add comment

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

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

1 Answer

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
add comment

Your Answer

 
discard

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