Restore SQL 2000 database on 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.