Best practice to configure backup for the VM running MSSQL 2008 database
NetBackup 5330 appliance configured with NetBackup version 7.7.1.
We are migrating backup to NetBackup and configuring backup for all the client server. And we have some of the VM's are hosted with MSSQL database. So I want to know what is the best method for the SQL database backup on VM and restore procedure for the SQL database.
1 - BMR backup for the VM + SQL backup for the database (Full+increment+log) =or=
2 - Snapshot backup for the VM (VMDK)+ SQL backup for the database (Full+increment+log)
What is preferred standard or best practice and what are the pros and corns, please provide your expert comment.
Any suggestion would be appreciated.
Thanks,
Hello,
this is my approarch:
- one policy of VMware type and "Enable SQL Recovery" attribute checked (for quick DR), running rarely
- another policy of MS-SQL-Server type and schedules according your RPO/RTO needs, running more frequently
I prefer VMware based backups/restores to BMR-based backups/restores, unless you are planning V2P conversions during recovery. However both are possible, with the following difference:
- after BMR restore, you must perform MS-SQL-Server DR steps first (master/msdb/model databases recovery), then go on with user databases restore
- after VMware restore where "Enable SQL Recovery" was employed, alll databases including master/msdb/model are restored to the time of VMware backup. So you can go on directly with user databases restore up to the required point-in-time
Briefly said, you can meet shorter RTO with VMware backup than with BMR backup.
regards
Michal