APA0876 (12/7/2012)
when you say create the SQL server cluster with same virtual name than the 2005. Can this be done while they both are on the same domain?
Please re-read, "Build your SQL 2008 cluster with the same instance name as the SQL 2005 box, virtual name is unimportant since it isn't gonna be the final."
Well we were thinking to leave the sql server cluster installation for the migration day because if they are on the same domain there can't be identical names at the same time.
No reason to wait, its better to have the new one up and ready and tested well before you are looking at a cutover. The won't have identical names until you change them, the instance names CAN be the same, they just can't be duplicated within a cluster. Virtual name must be unique on the network, but that name doesn't matter at this point.
Virtual named instance with this format so this how it will look:
OriginalVirtualnetworkname\OriginalInstance
So my question is: Can I do it before the migration day with a temporary Virtual network name?
Thanks I will appreciate your advise also if you can provide the steps you followed so I can verify mine.
Thanks a lot
On the network at the same time at the time of conversion you should have:
OriginalVirtualNetName\InstanceName
TemporaryVirtualNetName\InstanceName
After you migrate you will then change the original name and ip address to some other name/ip, this frees up that name/ip for use elsewhere. Using the old name/ip change the temporary name/ip to the old name/ip. Restart SQL and it will be using the previous name.
Clearer.
CEWII