April 2, 2010 at 12:49 pm
We are planning on moving a SQL 2000 Server to a new physical location. SQL Server was installed on Drive D: therefore the system databases and some user database are on drive D:. Drive D: is on SAN storage.
Drive C:\ (System Drive is local disks) (No SQL)
Drive D:\ SAN storage
Drive E:\ SAN storage
Drive F:\ SAN storage
The server name will remain the same, but the IP will change. We plan on entering a alias in DNS so users who connect using the name will still be able to.
The move as planned is to:
1. Backup everything.
2. Before shut down change SQL services to start manually.
3. Shutdown the server.
4. Start the SAN copy to the new datacenter location.
5. Remove the server from the rack and move to new Datacenter.
6. Rack the moved server in new datacenter.
7. When SAN copy complete, start the server.
8. Make sure SAN attached with Same Drive letters.
9. Change the IP,
10. Start SQL.
Will this work?
Are there any gotcha's we are missing?
Does SQL just need the same drive letters as before or does it keep a binary identifier of drives?
April 19, 2010 at 8:28 am
For SQL2000 we have moved all system and users datafile to new host with same drive letters and file paths without any problem.
My hope will be OK for you too.
Regards,
MShenel
April 19, 2010 at 8:32 am
Thanks for all the replys, the move was successfull.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply