September 6, 2002 at 2:13 am
I have to restore a SQL 2000 backup on a SQL 7 server. Does somebody knows how to?
September 6, 2002 at 3:22 am
You cannot do this, the backup files with 7 are only forward compatible not backward. 2000 backups cannot be restored to 7 only to 2000.
Edited by - antares686 on 09/06/2002 03:22:34 AM
September 6, 2002 at 6:48 am
That's what I thought but just to be sure ...
Perhaps a parameter when performing backup ? no?
September 6, 2002 at 7:40 am
Can't use the backup to restore a 2000 DB to 7.0, but you can migrate all the objects back using DTS package. I know what a pain.
-------------------------
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply