DB VMware snapshot vs Scripted DB backup

[sa1eh]

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?

[Michal_Mikulik1 · Accepted solution]

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

[sa1eh]

Thanks Michal for your fast response

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.

Actually we did Linux VM snapshot and we restored it and it was working fine.

[Michal_Mikulik1]

Hello,

yes it can be working, but it is not supported and configurable method from the NetBackup side.

regards

Michal

[Kleber_Marra]

Caso em produção haja um problema para restaurar a Veritas não te dará suporte por não ser suportado.