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 |
|
Josh_B
Starting Member
2 Posts |
 Posted - 2011-05-26 : 14:06:57
|
| Hey guys,I work in a data center and we currently have a legacy product that needs to be consolidated. We have 2 servers running MS SQL 2000 on Win 2003. Each server has roughly 10 databases. No reason for 2 servers [used to have hundreds on each server]. The company doesn't want to force these clients off the servers so I am trying to gather a plan to reclaim the hardware and power that it's costing us. How would I go about moving the DBs from 1 server to the next and can it be done transparently so the clients have no idea? I know the clients that connect to it via hostname will need to change the hostname in their code but most connect via IP so that IP can be added to the saved SQL box. Other than that I don't know enough about MS SQL to know what need to be done to move the DBs from one server to another without totally borking the whole thing. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-26 : 14:15:52
|
| Can you just create a new instance on the new machine?Have you thought about virtual machines?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Josh_B
Starting Member
2 Posts |
Posted - 2011-05-26 : 14:27:30
|
| Creating a new instance should work. Then I could config the IP on the new box so it would have the instance and the IP. Other than that, would I need to know each DB's password and such to move it correctly or would it simply be an export from one server and import to the other? |
|
|
|
|
|
|
Consolidate MS SQL 2000 Servers