Restoring a SQL2000 bkp on SQL7

  • I have to restore a SQL 2000 backup on a SQL 7 server. Does somebody knows how to?

  • 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

  • That's what I thought but just to be sure ...

    Perhaps a parameter when performing backup ? no?

  • 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

    Gregory A. Larsen, MVP

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply