March 30, 2009 at 11:46 am
Hi,
We have standalone default sql server 2000 instance.Now we are planning to upgrade to active/passive clustered sql sevrer 2005 using side-by-side upgrade method.
Our requirements:
1.No modifications to be done with respect to Application .i.e application shoud use the same default instance ABC
2.If we go for clustering, we can have the default instance but the IP Address will change right? In this case the application might not able to connect to the new instance even if it is default instance with same name ABC right?
please clarify me and tell me how to achive this with clustering
March 30, 2009 at 2:30 pm
There is no way to upgrade an existing instance to a clustered instance. You have to build the cluster and then install a new instance into the cluster.
The only way to avoid having to change the application is to:
1) Shutdown the existing system, install the new clustered instance using the old name and restore (or attach) the databases from the old instance. You cannot have two systems on the network with the same name.
2) Install the new clustered system with a new name. Move the databases and update DNS to have the old server names entry point to the new clustered instance name.
The best option, IMNSHO - is to create a new cluster, migrate the databases (using backup/restore or detach/attach), modify the application(s) to use the new clustered instance and shutdown the old instance.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 30, 2009 at 2:55 pm
like the man says, the cluster virtual name and ip address must be unique on the network
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply