Options
Restore SQL 2000 database on a SQL 2008 server
ITSyncForce
Posts: 7
I am trying to restore a backup created on SQL 2000 to a SQL 2008 server.
We use a backupscript that creates 4 files (4 threads on the server). When I try to restore the files I can add them to the restore dialog but SQL backup does not recognize the files as backup files.
Is this a known limitation or do I do something wrong?
We want the database in SQL 2008 to stay in SQL 2000 mode.
In the future we also will have setup where a database running on SQL 2008 (in SQL 2000 mode) will have to be restored on a SQL 2000 server will that be possible?
I hope somebody can help me with this.
We use a backupscript that creates 4 files (4 threads on the server). When I try to restore the files I can add them to the restore dialog but SQL backup does not recognize the files as backup files.
Is this a known limitation or do I do something wrong?
We want the database in SQL 2008 to stay in SQL 2000 mode.
In the future we also will have setup where a database running on SQL 2008 (in SQL 2000 mode) will have to be restored on a SQL 2000 server will that be possible?
I hope somebody can help me with this.
Comments
You don't mention how you created the SQL2000 backup that cannot be restored to SQL2008.
Chris