I am unable to restore database in form of .bak files using Microsoft SQL Server Management Studio Express.

It gives following error message:

Too many backup devices specified for backup or restore; only 64 are allowed.    
RESTORE HEADERONLY is terminating abnormally. (.Net SqlClient Data Provider)

Can you please help?


  • Which version of SQL Server did you use to create this backup? Do you have SQL Server 2000 installed? – Druid Mar 16 '11 at 10:34
  • I took backup from my webhosting server. It was SQL Server 2005. – meetpd Mar 16 '11 at 11:17

Looks like you are trying to restore backup on older version of MS SQL Server than the backup was made. For example, if you made backup on MS SQL Server 2008 and restore on MS SQL 2005.

In this case you need to install the correct version of MS SQL Server and move the data by Export/Import functionality.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.