Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

vmware snapshot and database corruption? Expand / Collapse
Author
Message
Posted Thursday, April 26, 2012 7:12 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 10:26 AM
Points: 634, Visits: 1,540
Anyone heard that vmware snapshots can cause database corruption on SQL Server databases? The VMware is ESX 4 running Windows 2008 R2, and SQL Server 2008 (and R2)

I hadn't heard this before, but someone asked me about it. My "google research" found 5-year old posts that indicate this, but recent posts seem to say it's fine.

Thoughts or opinions?

Thanks,
Cindy
Post #1290672
Posted Tuesday, April 8, 2014 1:16 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 8:01 AM
Points: 416, Visits: 1,345
CavyPrincess (4/26/2012)
Anyone heard that vmware snapshots can cause database corruption on SQL Server databases? The VMware is ESX 4 running Windows 2008 R2, and SQL Server 2008 (and R2)

I hadn't heard this before, but someone asked me about it. My "google research" found 5-year old posts that indicate this, but recent posts seem to say it's fine.

Thoughts or opinions?

Thanks,
Cindy


It is not recommended.

Any snapshot functionality that does not use VSS may leave SQL Server in an inconsistent state. This is because any backup product or solution that uses VSS, allows the SQL server disk to pause briefly (or that's the concept behind) so any in memory transaction or database activity can be backed up accordingly. When VSS is not used, there is a chance that something that should have been written to the disk (mdf file), was not, or viceverse, ending with a database that is not in a consistent state. Then when you start MS-SQL or try to open the database, it won't open.

If you are running SQL on VMware or HyperV, run regular SQL backups, native or RedGate and save those on a different drive or backup device. You may also use SAN backups but you must ensure they integrate VSS on its solution, to avoid the issue I just mentioned.
Post #1559672
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse