Post reply

restore a database on SQL Server 7

  • November 11, 2002 at 4:19 am

    #79662

    Is it possible to restore a database on SQL Server 7 using the 2000 backup? I have tried it but it seems to be that SQL Server 7 doesn't recognise the backup! Any insight?

  • November 11, 2002 at 7:50 am

    #440952

    Yo cannot restore the SQL Server 2000 Backup to SQL Server 7.But, you can do it the other way round.

  • November 11, 2002 at 12:11 pm

    #440985

    Yes,you are right. I have found out some info about it on Books Online. But I found a solution for my problem:

    I created the script of the database on 2000 and modified it (I have omitted 'COLLATE' ) and run the code on SQL Server 7.

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

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