Home Forums SQL Server 7,2000 General Is it possible to move database from sql server 2005 to server 2000 ..?? RE: Is it possible to move database from sql server 2005 to server 2000 ..??

  • To add on to what Barry said, there is no way to take a backup of a 2005 database and restore it on 2000, nor is it possible to detach a SQL 2005 database and attach it to SQL 2000. The file structure is different, the system tables are different.

    And before anyone suggests compatibility level, that just affects the T-SQL parser and the query processor, controlling how commands are interpreted. It does not affect the structure of the database file in an y way.

    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