Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dj463
Starting Member
11 Posts |
 Posted - 2011-08-22 : 11:23:41
|
| Hello All,I want to upgrade my SQL Server 2005 Standalone instance to clustered instance. Since Cluster uses a virtual server name and ip can i use the same name and ip used for my standalone instance? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Dj463
Starting Member
11 Posts |
Posted - 2011-08-22 : 12:32:15
|
| @Tara: What does reimaging OS mean? |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-08-22 : 12:37:35
|
| Reinstalling it.--Gail ShawSQL Server MVP |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Dj463
Starting Member
11 Posts |
Posted - 2011-08-24 : 16:55:30
|
| My Current environment is i have standalone instance of SQL Server 2005 installed on Windows server 2003(not clustered). I am just listing the steps which i intend to perform to migrate this instance to Cluster. Could you please let me know if these are correct.1)Install windows cluster and make my current server a node2)Take Standalone machine out of network. Make sure there is no entry for host name or IP address anywhere in the network.3)Install SQL Server cluster with a new clustered instance. keep IP address and Virtual Server name same as standalone instance.4)Restore databases and map logins on new clustered instance.5)Once this is completed, Test failover to other node. |
|
|
|
|
|
|
Upgrade stanalone instance to clustered instance