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 |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
 Posted - 2008-04-02 : 01:44:54
|
| Has anyone had experience of migrating from 2000 to 2005 on the same box , and maintaining the SERVERNAME\INSTANCE_NAME.What are some effective ways of migrating and retaining the same servername/instance name ?The issue revolves around minimising the use of extra boxes , as I would like to do the migration on the same server and keep the name the same .Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-02 : 23:21:40
|
| It'll convert sql2k instance to sql2k5 instance with same instance name, worked fine for me. Yes, should always keep good backup of all dbs just in case. |
 |
|
|
chetan_dba
Starting Member
21 Posts |
Posted - 2008-04-03 : 03:16:32
|
| Hi rmiao,Can u please explain what all things u have done while migrating / converting ur SQL 2000 to SQL 2005.What all things where there in your environment like - backup policy, log shipping, replication, etc.and let know also the steps followed in the migration.Thanks in advance.-- Chetan |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-03 : 23:11:53
|
| For in place migration, I just ran sql2k5 installation and choose upgrade existing instance. It migrated everything. |
|
|
|
|
|
|
Migrating 2000 to 2005 on same server