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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.