Post reply

Restore a SQL 2005 database backup to SQL Server 2000

  • October 1, 2004 at 2:03 pm

    #86623

    No we are testing the SQL Server 2005 new features, Now we meet  a problem that the database backup file from Yukon can not be restored to SQL Server 2000. Anybody know if there is a way to achieve it. Thanks 

  • October 4, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • October 13, 2004 at 12:47 pm

    #526568

    We had this problem today. We also tried to detach in 2005 and attach to 2000, did not work. Usually you can not downgrade the version, it is related to changes in system tables.

    I did not try DTS yet to push from 2005 to 2000. Another way would be to script a database or all its objects in 2005, run a script  in 2000 and then pump data.

    Regards,Yelena Varsha

  • October 10, 2005 at 5:31 am

    #596232

    Hi

    I am using SQL Server 2000 currently for my applications. In the process to test SQL Server 2005 Developer edition, i messed up and the default instance of SQL 2000 was updated with SQL 2005. Now all my databases are converted to SQL 2005.

    Is there a way that I convert the database back to SQL 2000. I have another instance of SQL 2000 running on which I can restore these databases.

    Any help would be greatly appreciated.

    Thanks for your replies in advance

    Dbhartiya

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

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