Click Here To Get Amazing Facebook Profile Covers,Status Messages

Too many backup devices specified for backup or restore; Only 64 are allowed SQL server 2000 error

No replies
parth's picture
parth
User offline. Last seen 2 years 35 weeks ago. Offline
Joined: 09/20/2009
I had my database in SQL Server 2005 Express but that was creating some problem due to increase in size of transaction log so i decided to shift it to another machine which has SQL server 2000.I backed up the database from SQL express and copied the .bak file to SQL server 2000 personal.
 
I created a database there and tried to restore it by choosing "from device" as restore option and specfied the copied .bak file as restore destination , select it and choose the restore option.
But on click of OK restore operation terminates with following error
 
Microsoft SQL-DMO (ODBC SQLState:42000)
 
"Too many backup devices specified for backup or restore; Only 64 are
allowed. RESTORE DATABASE is terminating abnormally."
 
Is it creating problem because of backward incompatibility.