14 Preparing for disaster
Disastrous data loss can be caused by a variety of factors, including data center fires, severe weather, human error, or even intentional sabotage. The goal of disaster recovery is to be prepared before these types of disasters strike, because your entire SQL Server instance may no longer be accessible and would need to be rebuilt and restored from the ground up.
Typically, disaster recovery for SQL Server consists of the following four parts:
-
Exporting and backing up all required items to disk
-
Moving export files and backups off-site
-
Testing imports and restores on a secondary server
-
Importing and restoring all the required items from disk in the event that a disaster occurs
Fortunately, dbatools makes this ...
Get Learn dbatools in a Month of Lunches now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
