Backup of sql server 2000 to restore on 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Backup of sql server 2000 to restore on 2005

Hi Gurus I have a backup of a database taken on SQL Server 2005. When I am trying to restore it on SQL Server 2000 I am getting problem. Please let me know the solution for this. very very urgent raj
Can’t go from 2005 to 2000 with backup and restore. You’ll have to export then import your data and objects…
MS allows to go in one direction when it comes to restores<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br />Solution:<br />Create a new database in 2000<br />Script all objects from 2005 and run the script in 2000 to crate the objects…<br />Import the data from 2005 using DTS/BCP…<br /><br /><br /><br />Mohammed U.
Hi, one more solution ; create a snapshot replication as SQL 2005 as publisher and SQL 2000 as subscriber, and then drop the replication. Madhu
]]>