Snapshot of ESXi 5.1 Windows 2012 R2 SQL server VM

Hi,

Is it possible/relevant to make a snapshot of a ESXi 5.1 Windows 2012 R2 SQL server VM?

J.
janhoedtAsked:
Who is Participating?
 
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
Often that is the case with SQL, and heavy SQL I/O, or VMware Tools or VSS is busted in the VM.

SQL Database can be problem matic, when reverting. Usually VSS interacts with SQL to ensure, it's intact.
0
 
GG VPCommented:
Yes!

From VMware,


A snapshot preserves the state and data of a virtual machine at a specific point in time.
The state includes the virtual machine’s power state (for example, powered-on, powered-off, suspended).

The data includes all of the files that make up the virtual machine. This includes disks, memory, and other devices, such as virtual network interface cards.


I would strongly suggest you to read Andy's well written article on Snaphsots,

HOW TO: VMware Snapshots :- Be Patient
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Yes, but the Question also is WHY ?

for what purpose, applying patches ?

Performance when writing to a delta disk is worse, and performance can be terrible.
0
 
janhoedtAuthor Commented:
I should have put it differently. Because there is a sql server on it, won't the data get corrupted in the snapshot?
Problem now is that snapshot won't work "error occured while quescing the virtual machine" but I do wonder if reverting to a snapshot would be revelant.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.