August 28, 2007 at 11:25 am
I need to restore a database form an SQL-2005 to an SQL-2000,
August 28, 2007 at 12:00 pm
The are incompatible, you will need to create a database on SQL 2000 an import the data using the Import/Expot process from SQL 2005 instance. But you may not be able to trasfer all the objects in the 2005 instance to 2000 due to difference in the systems.
September 3, 2007 at 7:27 pm
What about setting/changing the db compatability level from 90 to 80?
at the very least the table structure and data should come across?
------------------------------
Life is far too important to be taken seriously
September 4, 2007 at 12:10 am
Yes by changing the DB Compatibility level from 90 to 80 should work. It did work for me long back.
Provided you have not used any features specific to SQL 2005 within your database.
September 7, 2007 at 11:33 am
Changing the compatibility level will not work. There is no way to restore a SQL 2005 backup to a SQL 2000 server.
June 28, 2008 at 9:24 pm
Possible to restore SQL 2005 DB to SQL 2000 here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=186526&SiteID=1
Cheers,
June 28, 2008 at 10:29 pm
[font="Verdana"]Try the below article.
Moving SQL2005 db to SQL2000 db[/font]
Regards..Vidhya Sagar
SQL-Articles
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply