Groups | Blog | Home
all groups > sql server clustering > december 2006 >

sql server clustering : Physical move of clustered SQLServer



Edwin vMierlo
12/20/2006 12:00:00 AM
If you are fully re-locating the kit, and the IP addressing stays the same,
there should be nothing more to do on the cluster itself.

However;
- there is no alternative for a good backup and restore, ensure you have a
good back of your databases and cluster (and know how to restore in case of
a disaster, have your restore procedures ready)
- ensure that you know how to powerdown and powerup your miniSAN. Many
storage equipment have specific sequences in powering up and powering down.

Then for moving the kit, consider the following:
- set the cluster service to manual on both nodes, this to ensure the
cluster is not trying to start when relocated
- once relocated and booting your nodes, ensure that you have base
connectivity, IP's and all networking (including heartbeat) is working. All
software/networking, except cluster and clustered applications, must be
working at this point.
- set the cluster service to Automatic on Node 1 and start the cluster
service (only) on Node 1
- check your application / data, all should come online, all should be
functional
- when you are happy that all is working on Node1, set cluster service to
automatic on Node 2 and start cluster service on Node 2
- test moving all groups from/to all nodes, to ensure your cluster is
functional
- when your cluster is functional, all OK, then test client connectivity to
your databases

If you take a planned approach like the above steps, you can troubleshoot if
anything goes wrong after each step.
Plan your move in detail, make a checklist of steps, and execute step by
step, testing that each step is sucsesful before moving on to the next.

HTH,
_Edwin.


[quoted text, click to view]

adb2303
12/20/2006 2:17:40 AM
Hello,

All of our Intranet servers are physically moving from one datacentre
to another. We have already catered for the front-ends, but I need to
find out what needs doing to our clustered SQL Server 2000 environment.

We have a 2 node Win2k cluster, with SQL Server 2000 Enterprise
Edition. The database files are stored on a miniSAN. We're physically
picking up the kit, and moving it to another datacentre.

I need to know what considerations need to be made to bring the cluster
back-up, database intact, once it's in the new datacentre.

Any suggestions/recommendations are gratefully received.

Andrew
AddThis Social Bookmark Button