Regardless, in all cases, SQL Server backups of each database should be taken regularly. A whole VM snapshot for example that is reliant on VSS could incur an unacceptable long IO stun duration when it occurs. You should consider complimentary backup solutions that backup/snapshot the entire server (or VM) for SQL Server, but sometimes these technologies are limited or have too much of an impact on the server. Not hardware failure but ransomware (crypto-locking file) attacks have been the cause. Recently, by far the most frequent and common disaster recovery scenario for my clients has been the need for a complete, bare-metal rebuild or restore of the master database. Not many disaster recovery or SQL migration/upgrade scenarios require the SQL Server instance service master key to be restored.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |