SQL Server Performance

Migration issue

Discussion in 'SQL Server 2005 General DBA Questions' started by farr77, Aug 15, 2007.

  1. farr77 New Member

    can we migrate data or restore/attach data from SQL Server 2005(SP2) to SQL Server 2000(SP1)? is there any data loss or any effect? backword migration
    The reason I am asking because we migrated the sever from SQL Server 2000 to SQL Server 2005 but we are having some problem and thinking to go back to 2000 server.
  2. ndinakar Member

    You cam "migrate" from/to 2000/2005. But you cannot detach a 2005 DB and attach it to 2000 server (if after attaching with 2005 you changed the compatibility level to 90). You can however migrate the data back to 2000 db.
  3. MohammedU New Member

    As Dinakar mentioned, you can't detach/attach or backup/restore from 2005 to 2000... this has been discussed many times in this forum..
    If you search you may find more info on this...
    You'll have to script out your objects and run the scripts in the SQL 2000
    DB, then load your data.
    or
    You can try copy database option in DTS or SSIS package (I have not tested this...)
  4. satya Moderator

Share This Page