January 1, 2009 at 9:14 am
Can anybody help me on how to restore SQL server 2005 backup database to SQL Server 2000. Its not allowing to restore when I am using SQL 2000. I need to migrate the database from SQL 2005 to SQL Server 2000.
Thanks!
January 1, 2009 at 9:17 am
It can't be done. You can restore a database that was backed up with SQL Server 2000 on SQL Server 2005, but you can't do it the other way around.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 2, 2009 at 2:49 am
Yes.. You cannot do so.. since 2005 is highest version, old version 2000 can be reloaded to 2005 but u can't do the reverse from 2005 to 2000..
since some of the components was updated to new one..!
Thanks and Regards,
Ums
Regards,
Ums
January 2, 2009 at 4:02 am
ervin_brosas (1/1/2009)
I need to migrate the database from SQL 2005 to SQL Server 2000.
The only way to do that is to script all of the objects out, bcp all the data to flat file, create a new database on SQL 2000, apply the scripts and then reload the data.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy