2012-02-15 10:17 AM - edited 2015-12-18 01:21 AM
Oracle has the ability to use crash consistent snapshots as valid backups (TR-3858) which means that entire volumes of Oracle databases can be easily backed up and restored with little intrusion into the guest OS at the time of the snapshot.
I am doing my due diligence on MSSQL and was wondering if there is anything that can be done to provide the same capability for MSSQL. While we do have the SMSQL software, we are looking for an easier methodology to deploy, since we have literally hundreds of MSSQL databases.
Running NFS datastores to VMware
All database/OS files are contained within VMDKs on the same volumes (no consistency groups needed)
Various MSSQL versions...
Average database size ~300Gb
2012-06-15 05:21 AM
I apologize - it seems that I left out a few details: While we can get a crash consistent backup at any time via snapshots, when you restore MSSQL from a crash consistent backup (snapshot), the database opens without any chance of applying transaction logs. If the ability to apply logs is required, the backup has to be application consistent (e.g., using.SnapManager for SQL). Oracle and DB2 do *not* have this issue.
Sorry I omitted the important details.
2012-06-15 01:23 PM
Providing you will be lucky enough to recover from a crash consistent MS SQL snapshot - it doesn't have the same 4k block granularity / alignment as Oracle.