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.
| Author |
Topic |
|
kieran5405
Yak Posting Veteran
96 Posts |
 Posted - 2007-10-18 : 08:48:01
|
| Hi,I have an existing sql server 2000 installation on one server. I now need to take one 2000 DB and restore it to a new sql server 2005 installation (on a different server). What is the best way to do this. I can not upgrade the sql server 2000 installation to 2005. Basically i hoping all i need to do is backup the 2000 db and then restore it on the new sql 2005 server.Is this possible...thanks for all help. |
|
|
langdu
Starting Member
9 Posts |
Posted - 2007-10-18 : 08:56:54
|
| Yes, you can. I did that long time a go. I backed up a 2000 db and restored it on a new SLQ 2005 server. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-18 : 10:16:20
|
| See also:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Migrating+to+SQL+2005+Hints+and+Tips |
|
|
|
|
|
|
move sql 2000 backup to sql 2005