September 24, 2015 at 2:46 am
Hi,
have this task to move in fasted way a two node cluster on the new machines and new SAN.
Which is the fast mode to move the all systems -nodes,databases?
thanks,
BR,
Hadrian
September 24, 2015 at 8:16 am
I come back with some details- we have two node cluster 2012 and we should move on new SQL cluster 2012 with disks on the new SAN.
September 24, 2015 at 9:05 am
Hadrian (9/24/2015)
I come back with some details- we have two node cluster 2012 and we should move on new SQL cluster 2012 with disks on the new SAN.
Install the new cluster and get the sql instance online using a temporary network name. Script out all logins, jobs, etc to the new instance.
When you're ready to move backup and restore the user databases and then finally take the current cluster down and change the temporary network name on the new instance to use the existing name on the old instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 25, 2015 at 9:49 am
to minimize service disruption you can restore with no recovery on your new cluster your last full backup from the old. then during a maintenance window just run a differential backup and restore with recovery.
I just did this for a 2 TB SharePoint farm and we were down for about 20 minutes.
Another option is to set up mirroring between the two clusters which in theory could reduce the required outage to a matter of the few minutes it takes to update connection strings or DNS CNAMEs. Also did this as a proof of concept for the above migration.
Both are good ways to minimize your down time.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply