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.
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.
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...)
http://msmvps.com/blogs/ssqa/archiv...2005-database-to-sql-server-2000-version.aspx fyi on what they said above [].