Problem Restoring a DataBase from SQL Server 2005 Express toSQL Server 2000
-
Hi guys, I have a problem I can't restore a database from SQL Server 2005 Express to my SQL Server 2000 it appears an error that it says 'Error 3205: Too many backup devices specified for backup or restoring only 64 are allowed RESTORE FILELIST is terminating abnormally'...
what can I do ?..., can I restore a database from an older version of SQL Server to a new version or not ?...
Thanks...
-
If you are trying to restore a database from SQL Server 2005 Express to SQL Server 2000, you are trying to restore from a newer version of SQL to an older version. This is not supported the last I had checked.
-
As stated in the previous reponse, you cannot restore 2005 db to a 2000 database. Your only option is to recreate the schema, then export/import the data.
-
Backup Restore is one way free way...2000--->2005...
If you want to go 2005---->2000... You have to take side roads with may stops...(Export/Import)...
1. Create new db in sql 2000
2. Script the objects in 2005
3. Create the objects scripted in step2 in sql 2000 without contraints and indexes and Triggers...
4. Copy the data using DTS/SSIS from 2005 to 2000
5. Create the constraints, indexes and triggers...
MohammedU
Microsoft SQL Server MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply