3 ms·
It depends on the DBMS, its configuration, the host OS, its configuration, and many other details. Snapshotting running databases is possible and often "just wo
by barryrandall 3y ago
It depends on the DBMS, its configuration, the host OS, its configuration, and many other details. Snapshotting running databases is possible and often "just works," but you should always verify that before relying on this functionality in production.
- codetrotter 3y ago> you should always verify that before relying on this functionality in production Yep :) At said company where I was using ZFS snapshots for the servers I administered, I additionally had a nightly cron job to dump the db using the tools that shipped with the DBMS. Just in case something with the ZFS snapshots fricked itself :)
- sitkack 3y agoSmart. I did a daily dump of my prod database to my local workstation, needed it for prod corruption issue because ops was only doing weeklies.