June 12, 2015 at 7:48 am
We have a two node cluster on SQL Server 2008 & OS on Windows 2008 R2.There are two instances of this cluster.What is the best way of Virtualizing this system ?
Ideally the plan is to uncluster our 2-node active/passive SQL 2008 cluster with the intention of then virtualising the remaining single node.
Both the instances have been into Node 01 right now.Is evicting the Node 02 from the cluster after stopping the cluster service enough before starting the P2V Process?
June 12, 2015 at 8:36 am
P2ving a cluster is not my preferred route to be honest.
Which hypervisor are you using?
It sounds like you would like to drop the cluster for a standalone instance is that correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2015 at 2:05 pm
We are using Vcenter and essx
June 12, 2015 at 2:12 pm
I am just looking at the best way to do this.Easy way to do this suggested by some was evicting the unwanted node,remove the cluster service and then P2V
June 12, 2015 at 2:24 pm
Pery,
There are 2 Instances which includes two separate SSRS db's.
If there was only one instance it would have been easier,but since we have got 2 instances the idea was to have both of those put under one Noe (Node 01,which is already done ) and then shutdown Node 02 , get rid of the cluster service,the start P2V
June 15, 2015 at 8:43 am
hari.devadas 4119 (6/12/2015)
Easy way to do this suggested by some was evicting the unwanted node
This will leave you with a single node cluster
hari.devadas 4119 (6/12/2015)
remove the cluster service
To remove clustering on the final node you'd need to destroy the cluster and that would leave with no sql instance so a P2V would be pointless.
Do you want to convert the clustered instances into standalone instances, this is how it sou8nds to me??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2015 at 8:52 am
Yes, this would essentially P2V a single node cluster.my question would that work ?
June 15, 2015 at 9:13 am
hari.devadas 4119 (6/15/2015)
Yes, this would essentially P2V a single node cluster.my question would that work ?
No!!!
You're still not providing a definitive answer to my questions.
Do you want to end up with a VM with standalone instances???
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 15, 2015 at 9:19 am
VM with stand alone instance is fine
June 15, 2015 at 12:17 pm
A VM,One node , 2 instances on that i.e should get the job done
June 18, 2015 at 10:00 am
Perry,
We evicted Node 02 from the SQL 2008 Clusterand now on course for testing the P2V on Node 01 now. Once I converted the one node cluster it booted fine but all the disk have reservations and are not accessible. After troubleshooting and doing some research on this I haven’t been able to find a resolution. Any ideas ?
June 19, 2015 at 7:31 am
You best bet might be to build a new VM, install SQL Server and restore everything to the new SQL Server VM
June 23, 2015 at 3:11 am
all the disk have reservations and are not accessible
Without seeing your machines, my guess is that you have a problem with the Quorum. Check what type of quorum you are using and check if it is compatible with a single node cluster.
When I build a cluster for testing FineBuild I very often start with a single node and use a disk witness (the original style of quorum), which works happily with a single node. If you do find you have a problem with your type of quorum you can use the Failover Manager GUI to change the type of quorum you are using.
If you can get your cluster working there are a number of ways you can P2V your OS. I have found that with W2008 and W2008R2 doing a P2V means you need to re-activate Windows. Also make sure you P2V using the same CPU vendor - P Intel to V Intel or P AMD to V AMD normally works but mixing vendors gives interesting BSOD messages.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
June 23, 2015 at 5:58 am
hari.devadas 4119 (6/18/2015)
Perry,We evicted Node 02 from the SQL 2008 Clusterand now on course for testing the P2V on Node 01 now.
Why on earth have you done that at this stage?
hari.devadas 4119 (6/18/2015)
Once I converted the one node cluster it booted fine but all the disk have reservations and are not accessible. After troubleshooting and doing some research on this I haven’t been able to find a resolution. Any ideas ?
whats the state of the role in cluster manager?
Where was your planning before doing anything?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 8:26 am
We got the reservations on the cluster disks resolved
Run powershell as administrator
import-module failoverclusters
Clear-ClusterDiskReservation -Disk 6 -Node node2 -Force
node2 is your cluster node server name
Disk 6 is what you see on the disk manager keeps the reserved disk.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply