Hi,
Is it possible to take an application consistant backup of a mssql 2012 server, without any production interruption?
Is it possible to take an application consistant backup of a mssql 2012 server, without any production interruption?
live backup of mssql
- Thread starter Ejdesgaard
- Start date
did you try with available methods and found any problems?
also, if possibile describe your pve version, vm and backup job config
Marco
also, if possibile describe your pve version, vm and backup job config
Marco
No
Last week I put an order up for a testing environment, 3 hosts. I'm planng on setting ceph+proxmox up and now with the release of 3.2 I'l proberbly use the proxmox ui for ceph.The reason i'm asking is that every other Hypervisor or VM backup vendor that I know of, promote application aware backup of windows, with vss, oracle sql, etc. But I haven't found any such marketing talk on proxmox.com and google haven't helped.
For a database you should always use the tools provided by the database for making hot consistent backups. No tool what so ever will ever be able to make hot consistent backups of a database but the tools supplied specific for that database.
Yes, if this has to do only with mssql (or any other rdbms) consistency, you can't beat tools provided by the database for making hot consistent backups.
But if you're also concerned about any particular problem on the (virtual) hw side, caused (eg) by a high activity rdbms running during backup, or else, while I did not particularly expermient such troubles, here and there in the forums there is someone who experiments troubles, but I feel it is often some physical hardware issue or other specific node issue.
Marco