Solved

Snapshot of ESXi 5.1 Windows 2012 R2 SQL server VM

Posted on 2015-01-12
4
237 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

In this article, I will show you HOW TO: Create your first Windows Virtual Machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, the Windows OS we will install is Windows Server 2016.
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
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 …
Advanced tutorial on how to run the esxtop command to capture a batch file in csv format in order to export the file and use it for performance analysis. He demonstrates how to download the file using a vSphere web client (or vSphere client) and exp…

752 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