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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-08-30 : 12:16:43
|
| Hi,We are moving sql instances from cluster to vm. Our plan is as follows for cutover:1. Restore last trans log backup from cluster to vm.2. Take resource group offline related to that instance.3. restore last trans log on vm with recovery.4. Bring application onlineWe have 3 instances on cluster (active/passive). We will move these instances one by one and will take these resource groups in cluster offline and will set autostart property flase in cluster admin for that group.Please let me know if that is fine, any issue and how we will remove cluster once all instanced removed. How don't need cluster after that. Definitely we will keep this cluster availale with no resouce group online for few months as backup.Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-08-30 : 12:29:25
|
| You can also establish database mirroring between the instances, fail over to the mirror (VM), then turn off the mirroring once it's settled. This is essentially what you're doing with the log backups, but the downtime is minimal, possibly zero. |
 |
|
|
|
|
|
cutover (cluster)