DB VMware snapshot vs Scripted DB backup
Our backup senario:
We created two servers ( 1 Linux - 1 Windows ) for testing in Linux we installed MYSQL DB with one database and two tables and we did the same on Windows but instead of MYSQL we installed SQL server and we did the backup using Veritas Netbackup snapshot and then we deleted the databases from both servers and we restored the backup from snapshot and it's was perfect.
My question is for backing up DB
is it better to use VMware snapshot or using script and agent to take DB records?
And if snapshot is better is there a way to take the snapshot for the DB only to increase both the backup and restore processing time?
Hello,
several notes to your questions:
- the main pros of VM+DB snapshot method is a rapid DR in the case of the whole VM failure. It is a quickiest way to bring VM+DB back online
- the main cons is that you can only hardly achieve low RPO for databases and you cannot achieve DB Point-in-time restore capability at all
Thus from my point of view it is optimal to combine both methods - so use VM/DB snapshot method less frequently and agent-based backup method more frequently
Note: you cannot configure VM+DB snapshot method for Linux VMs and MySQL databases, you can do it just for Windows VMs and Microsoft databases.
regards
Michal
