Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 restore (migrate) database from MS SQLserver 2005

Author  Topic 

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-11-01 : 09:59:21
can we restore (migrate) database from MS SQLserver 2005 to MS SQLserver 2000

Pls reply.

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-11-01 : 10:06:10
You can't do a restore or downgrade but you can export the data using "Generate Scripts" and "Script all objects" and choosing "Script For Server Version" and select SQL Server 2000.




Future guru in the making.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-11-01 : 10:10:39
See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Restore%20SQL%202005%20to%20SQL%202000%20via%20Downgrade
Go to Top of Page
   

- Advertisement -