Question

Locked

I need to restore a Database in SQL 2000

By Vinto ·
I need to restore a Database in SQL 2000 but i get the error that "Too many backup devices specified for backup or restore; Only 64 are allowed. RESTORE DATABASE is terminating abnormally."

What does that mean?

The backup was done in SQL 2005 could this be the problem, and what could be the solution.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Yeah that probably is the problem.

by cmiller5400 In reply to I need to restore a Datab ...

Yeah that probably is the problem. SQL databases are not upwards compatible. Meaning you can't use a SQL2005 database on a SQL2000 server. Different format.

A quick google search (took me less than 5 seconds to find this link --> http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/46e3ecf9-6eab-4aa0-9453-11e7269efb6e/

Collapse -

How to restore SQL 2005 DB to SQL 2000

by Vinto In reply to Yeah that probably is the ...

Thanks for the link cmiller5400. I will try that out as my senior developer uses SQL 2005 and I use SQL 2000.
Thanks a million.

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Forums