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 |
|
ras2a
Yak Posting Veteran
66 Posts |
 Posted - 2006-03-23 : 07:08:12
|
| I need to migrate our SQL server and databases to another (Brand new) server. The new server disk setup is different to the old server; The new server is setup as RAID5, the old server is not (just several partitions). For all intents and purposes it is the same, though, as the older SQL instance and all DBs are on the C:\ partition - the new server is just setup with one logical drive in RAID5..just C:We are not decommisioning the old server (as it's our DC), but I need to be able to get SQL 2000 server on the new machine with the minimum downtime - What's the best way to do this?Note: I also intend to keep the existing SQL instance on the older server, as I want to use it as a failover server later on. Therefore the new server will have a new DNS name and new IP - Will this cause major problems?Many thanks indeed for any help you can giveCheersCraig |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2006-03-23 : 09:42:29
|
| This will only cause problems if you have DTS packages, you will need to change all the connection properties, it will also affect any replication you have set up..Also, why would you only want 1 logical drive for your RAID? This will probably slow the server down a fair bit.. |
 |
|
|
ras2a
Yak Posting Veteran
66 Posts |
Posted - 2006-03-26 : 11:08:24
|
| May I ask, what are DTS packages? Also, I'd set 1 logical drive for the RAID config as I figured there may (otherwise) be problems - At present, our SQL server only caters for around 25 members of staff and in reality only about half this number are ever accessing it at the same time. I assume 1 logical drive will (performance wise) be sufficient?thanks againCraig |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
|
|
ras2a
Yak Posting Veteran
66 Posts |
Posted - 2006-03-27 : 11:57:00
|
| Thanks a lot, Rick |
|
|
|
ras2a
Yak Posting Veteran
66 Posts |
Posted - 2006-03-31 : 05:03:05
|
| Just to bump this, the server we are planning on moving to will be a completely different name from the original server it's currently installed on - Should this be ok? I will, I assume, have to update ODBC connections for our clients to point to the new server namethanksCraig |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-03-31 : 10:01:28
|
| remember to cater for orphan users. see the FAQ in the beginner section here written by Kristen. |
|
|
|
|
|
|
|
|
Migrate SQL to new server with different name?