Start Free Trial
VMWare - Independent Disks
In order to get snapshots enabled on a SQL server VM, I need to change some INDEPENDENT disks to normal disks. These are VMDK's on a NetApp SAN formatted with VMFS.
Is there any reason why I shouldn't just shut the VM down, uncheck the INDEPENDENT checkbox, and boot the VM?
I'm installing VEEAM, and currently I cannot get backups of these disks because they are not able to be snapshotted.
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
There is no reason at all, normally virtual disks by Default, do not have any tick box set to INDEPENDENT .
Is this something you have changed in your VMs, to stop the VM being snapshotted?
I agree with the above statements. I would also recommend installing the Netapp VSC 4.1 and performing SMVI backups if you have purchased the license. If you're using SnapManager for SQL be carefull in doing your backups since the different VSS agents can sometime step on each others toes.
Thanks for all of the tips...we inherited an environment that appears to have a SQL box that has not been backed up in ... about a year. 4 of 8 VMDK's are INDEPENDENT, and there does not appear to be any snapshotting happening in the NetApp either....the best part is that I asked the DBA onsite if there is at least a maintenance plan on the SQL db and his pause of 10 seconds told me .... NOPE. Amazing.
So shutdown, uncheck, start back up, and we're good? Research shows that making a SQL disk independent is a best practice for performance, but I think that assumes a SQL maintenance plan or some other backup plan....of which there is nothing.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Check your Netapp licensing and see if you have Snapdrive and SnapManager for SQL, this can make your life a lot easier and your backups a lot faster. Best way to do this is to login to your Netapp portal @ now.netapp.com
Plans and Pricing
Certified Expert Program
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent