The Focus of Disaster Recovery

If you create some very solid, time-tested mechanisms for re-creating your SQL Server environment, they will serve you well when you need them most. Following are the things to focus on for disaster recovery:

• Always generate scripts for as much of your work as possible (anything created using a wizard, SMSS, and so on). These scripts will save your hide. They should include the following:

• Complete replication buildup/breakdown scripts

• Complete database creation scripts (DB, tables, indexes, views, and so on).

• Complete SQL login, database user IDs and password scripts (including roles and other grants)

• Linked/remote server setup (linked servers, remote logins)

• Log shipping setup (source, target, and ...

Get Microsoft® SQL Server 2008 R2 Unleashed 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.