Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

Thanks!

share|improve this question

migrated from stackoverflow.com Mar 17 '11 at 0:49

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

    
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

1 Answer 1

up vote 1 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

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

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