VMware

This Question is Not Answered

1 "correct" answer available (10 pts) 2 "helpful" answers available (6 pts)
1 Replies Last post: Nov 6, 2009 8:50 PM by jjahns  

VDR and High I/O SQL Server posted: Nov 6, 2009 8:36 PM

Click to view jjahns's profile Enthusiast 30 posts since
Mar 19, 2007
This probably goes beyond support, so I am just testing this.

Here is a description of my environment.
We have a SQL 2000 server running on a Windows 2003 x64 VM. MDFs are located on a separate VMDK. LDFs are located on a separate VMDK. Both of these have been made independent persistent VMDKs, so they do not get snapshot.

Using the freeze scripts, I was able to use osql to call a stored procedure I created for backing up the databases on the VM, and then pause the MSSQLSERVER service so the snapshot can occur. Once the snapshot gets done, the MSSQLSERVER service is set to continue. This seems to be working very well without killing the applications on the VM that use the database instance.

I have not tested this in VDR yet. But I worry that deduplication may not matter here, since I am overwriting the same bak file for the backup of each database. WIll VDR be that smart and know what to do? Or will the block arrangement for that bit of data be completely different and it backs it up again?

Am I alone in this method? Can someone shed some insight?

VMware Developer

SDKs, APIs, Videos, Learn and much more in the Developer community.

Learn More

Developer Sample Code

Increase your developer productivity with VMware API sample code.

Learn More

VMworld Sessions & Labs

Online access to the latest VMworld Sessions & Labs and online services.

Learn more

Purchase PSO Credits Online

Purchase credits to redeem training and consulting services online.

Buy Now

Community Hardware Software

View reported configurations or report your own.

Learn More

VMware vSphere

Come witness the next giant leap in virtualization.

Register Today

Communities