Post reply

Restore backup file from sql server 2005 to 2000

  • February 8, 2007 at 12:39 am

    #116117

     I have a problem in sql server 2000. I want to restore backup file on sql server 2000, which has been backuped on sql server 2005.

    Please help me out from this.

  • February 8, 2007 at 12:45 am

    #688468

    I would say, we cannot restore backup of 2005 onto 2000. NO BACKWARD COMPATIBILITY. Altough look for yourself if there is any option available when backing up the database, to set compatibility level. I think there might be one available.

    - Rattu

  • February 8, 2007 at 12:52 am

    #688471

    I dont think there is a way to restore a SQL 2005 backup to a SQL2000 server however you can move the Data and Schema.

    If you are not using any SQL 2005 types you might want to look at scripting the schema and then using somthing like BCP to move the data (or you can use a third party tool like Red Gate's SQL Compare and SQL Data Compare which will move just the data which is different on the two machines).

     

    - James

    --
    James Moore
    Red Gate Software Ltd

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

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