September 2010
Intermediate to advanced
1704 pages
111h 8m
English
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 ...