July 5, 2007 at 3:58 am
I have two Windows 2000 servers (Advance Edition) to form a Windows Cluster. I also install MS SQL 2000 Enterprise Edition on the cluster to form a MS SQL cluster. Now, I want to upgrade the hardware and OS (but keep on using SQL 2000), so I install Windows 2003 server Enterprise Edition on two new servers to form a new Windows Cluster. I am planing to install MS SQL 2000 Enterprise Edition on the new cluster, so the old SQL cluster and new SQL cluster are side by side. I would like to know how to transfer everything (such as system databases, users database, sql user account, password and maintenance plan jobs etc) from old SQL cluster to new SQL cluster? And how to switch over from old SQL cluster to new SQL cluster?
Another problem of MS SQL cluster is to rename the SQL Cluster name (i.e. switch over from old cluster to new cluster). If the new SQL cluster uses different cluster name from the old SQL Cluster, the job (created by old SQL cluster name) in new SQL cluster cannot be modified or deleted. So any idea to solve this problem?
Thanks
July 6, 2007 at 2:14 pm
Clusters are very difficult to do. Depending on how easy or in depth your install is will dictate your move plans. Do you have a very small simple installation ? Small databases, small amt of logins, no DTS packages, very simple Maintenance plans ? OR do you have alot of large dbs with alot of DTS packages that are not easily recreateable with alot of logins ?
When we moved our cluster to new hardware I simply generated a script for the logins, created new empty dbs on the new cluster, created the logins, then did a backup restore of the databases. Then for the final piece was shutdown old cluster and thenwe created a dns entry on the network for the old servername to point to the new hardware and we were done. For the maintenace plans i simply just created new ones on the new server after all dbs were restored there.
July 10, 2007 at 12:54 am
Hi Markus,
Thank you for reply!
If I setup a new SQL cluster with new cluster name and new cluster IP, and then I update the DNS entry (old SQL cluster name pointing to new SQL cluster IP) for switching over from old SQL cluster to new SQL cluster. Is it any drawback or potential problem by using this method to switching over?
Thanks a lot !
July 10, 2007 at 5:42 am
That is how we did it. Just make sure you shutdown the old server first and then create the dns entry of the old name pointing to the new server cluster name.
July 10, 2007 at 7:12 pm
Hi Markus,
Thank you very much !
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply