All geek questions in one place

Hyper-V Snapshot Backup Strategy Suitable for SQL Server Production?

Therefore, SQL Server 2008 in Hyper-V is a supported configuration and should work well while you use fixed or pass-through disks and increase the processor / memory settings accordingly. My question is: can I use snapshots as a reliable backup mechanism or can I use a proven and reliable maintenance plan to perform my backups?

+3
source share
2 answers

You should not use Hyper-V snapshots as a backup strategy for SQL. Stick with something (built-in or otherwise) that will backup SQL knowledge.

Hyper-V snapshots (in my opinion) should only be used on production servers for very quick recovery after a failure. If you are updating, take a picture first, check when it is done right away, then take a picture. Such things should be done next to your regular backups, and not instead of it.

If you want to go to Hyper-V snapshots as your only backup strategy, you will lose the opportunity to restore your database to another server and restore the database in a timely manner - among other things, I'm sure I just don't think about it now.

+4

Hyper-V SQL Server . , SQL Server - , Microsoft SQL Server , .

http://support.microsoft.com/kb/956893/en-us

0

Source: https://habr.com/ru/post/1717270/

More articles:


All Articles