Avatar of jkeegan123
jkeegan123
Flag for United States of America asked on

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.

Thanks!
VMware

Avatar of undefined
Last Comment
Paul Solovyovsky

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
FilipZahradnik

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?
Paul Solovyovsky

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.
jkeegan123

ASKER
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!
Walt Forbes
Paul Solovyovsky

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