Solved

Snapshot of ESXi 5.1 Windows 2012 R2 SQL server VM

Posted on 2015-01-12
4
232 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
ID: 40543882
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 120
ID: 40543900
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
ID: 40543906
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 120

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 500 total points
ID: 40543910
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Last article we focus in how to VMware: How to create and use VMs TAGs – Part 1 so before follow this article and perform the next tasks, you should read the first article how to create the TAG before using them in Veeam Backup Jobs.
This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
Teach the user how to use configure the vCenter Server storage filters Open vSphere Web Client:  Navigate to vCenter Server Advanced Settings: Add the four vCenter Server storage filters: Review the advanced settings: Modify the values of the four v…
Teach the user how to configure vSphere clusters to support the VMware FT feature Open vSphere Web Client: Verify vSphere HA is enabled: Verify netowrking for vMotion and FT Logging is in place or create it: Turn On FT for a virtual machine: Verify …

680 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