Solved

Snapshot of ESXi 5.1 Windows 2012 R2 SQL server VM

Posted on 2015-01-12
4
218 Views
Last Modified: 2015-01-12
Hi,

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

J.
0
Comment
Question by:janhoedt
  • 2
4 Comments
 
LVL 5

Expert Comment

by:GG VP
Comment Utility
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
 
LVL 117

Expert Comment

by:Andrew Hancock (VMware vExpert / EE MVE)
Comment Utility
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
 

Author Comment

by:janhoedt
Comment Utility
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
 
LVL 117

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
Comment Utility
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

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

When we have a dead host and we lose all connections to the ESXi, and we need to find a way to move all VMs from that dead ESXi host.
Will try to explain how to use the VMware feature TAGs in the VMs and create Veeam Backup Jobs using TAGs. Since this article is too long, I will create second article for the Veeam tasks.
Teach the user how to use create log bundles for vCenter Server or ESXi hosts Open vSphere Web Client: Generate vCenter Server and ESXi host log bundle:  Open vCenter Server Appliance Web Management interface and generate log bundle: Open vCenter Se…
Teach the user how to use vSphere Update Manager to update the VMware Tools and virtual machine hardware version Open vSphere Client: Review manual processes for updating VMware Tools and virtual hardware versions: Create a new baseline group in vSp…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now