July 18, 2006 at 9:24 am
What is the procedure to change SQL Server Cluster IP address. Its a Active/Active 2 node microsoft cluster of SQL Server 2000 enterprise version on Microsoft Windows 2003 Enterprise edition
July 18, 2006 at 9:35 am
with very great care, and after asking yourself if you really want to do this! If it's a production or critical server then probably you don't.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
July 18, 2006 at 12:42 pm
100% with Colin here. If you can afford to build a "new" cluster and perform a DB migration it will be A LOT safer!!!
Cheers,
* Noel
July 19, 2006 at 5:04 am
Thumbs up for Collin !
In theory it should be done using Cluster Administrator.
"How to change the network IP addresses of SQL Server virtual servers" :
http://support.microsoft.com/kb/244980/
http://support.microsoft.com/kb/230356
SQLServer itself does not store its ipaddress, so changing it should not be a problem, but you'll have downtime !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 19, 2006 at 10:24 am
I agree, schedule the time to build a new cluster if at all possible. If you do not take this approach then you may be in for the same amount of downtime (if not more) if the IP Address change 'goes south ... At least with a new cluster you can have everything ready to go and just detach/copy/attach the databases !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
July 20, 2006 at 8:17 am
SQL Server does store the virutal server IP at it's in the registry. Its been months since I changed our cluster IP so I don't remember where. However, running the SQL install after the IP change will take care of this. You will have to remove the old IP and add the new IP.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply