Post reply

SQL Server Backup Database Unable to Restore to SQL 2000

  • January 1, 2009 at 9:14 am

    #197984

    Can anybody help me on how to restore SQL server 2005 backup database to SQL Server 2000. Its not allowing to restore when I am using SQL 2000. I need to migrate the database from SQL 2005 to SQL Server 2000.

    Thanks!

  • January 1, 2009 at 9:17 am

    #919955

    It can't be done. You can restore a database that was backed up with SQL Server 2000 on SQL Server 2005, but you can't do it the other way around.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • January 2, 2009 at 2:49 am

    #920148

    Yes.. You cannot do so.. since 2005 is highest version, old version 2000 can be reloaded to 2005 but u can't do the reverse from 2005 to 2000..

    since some of the components was updated to new one..!

    Thanks and Regards,

    Ums

    Regards,
    Ums

  • January 2, 2009 at 4:02 am

    #920169

    ervin_brosas (1/1/2009)

    I need to migrate the database from SQL 2005 to SQL Server 2000.

    The only way to do that is to script all of the objects out, bcp all the data to flat file, create a new database on SQL 2000, apply the scripts and then reload the data.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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