Luetkehoelter Pro SQL Server Disaster Recovery

1. ed
ISBN: 978-1-4302-0601-9
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 350 Seiten

This book explains how to implement an effective disaster recovery strategy for SQL Server 2005 and 2008 databases. It details powerful tools and features for data backup and disaster recovery present in SQL Server 2005 and enhanced in SQL Server 2008. Users of SQL Server 2000 will find that the options for handling disaster recovery have dramatically increased. This book explores those options by examining the technical details of disaster recovery features and then applying that knowledge to practical scenarios. Also covered are fundamental changes to disaster recovery capabilities and common issues to expect when using new features.

James Luetkehoelter is an MSCE, MSCD, MCDBA, MCT, and Oracle Certified Professional who has been working in the database field for more than a decade. He is currently the principle consultant and owner of Spyglass LLC, a data-centric consulting company. James is a frequent presenter at SQL Server conferences, both in the U.S. and in Europe. His teaching and presenting style is best described as 'eclectic,' though some may say 'just plain goofy.' In his spare time, he catalogues the various pronunciations of 'Luetkehoelter.' He is currently at 2,017 distinct variations.

Autoren/Hrsg.

Luetkehoelter, James

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;6
3;About the Author;16
4;About the Technical Reviewer;17
5;Introduction;18
5.1;Who This Book Is For;19
5.2;How This Book Is Structured;19
5.3;Contacting the Author;21
6;What Is Disaster Recovery?;22
6.1;Defining Disaster Recovery;22
6.2;Disaster Recovery, High Availability, and Business Continuity;24
6.3;Disaster Categories;26
6.4;Disaster Recovery from a Technical Perspective;31
6.5;Caveats and Recommendations;32
6.6;Summary;33
7;Making Database Backups;34
7.1;A Brief Review of SQL Server Storage;35
7.2;SQL Server Recovery Modes;37
7.3;T- SQL Backup;42
7.4;Full Backup;49
7.5;Log Backup;49
7.6;Differential Backup;50
7.7;Backup File Sizes;50
7.8;Error Checking;52
7.9;Securing Backups;53
7.10;Striped Backup;53
7.11;Mirrored Backup;56
7.12;Copy- Only Backup;57
7.13;Additional Backup Considerations;58
7.14;Backup and Disaster Categories;59
7.15;Caveats and Recommendations;60
7.16;Summary;62
8;Restoring a Database;63
8.1;Restore vs. Recovery;64
8.2;Availability During Recovery;66
8.3;T- SQL’s RESTORE Command;67
8.4;Databases in SUSPECT Status;91
8.5;Restore and Disaster Categories;92
8.6;Caveats and Recommendations;92
8.7;Summary;93
9;Backing Up and Restoring Files and Filegroups;94
9.1;A Brief Review of Filegroups;95
9.2;Backing Up and Restoring Files;106
9.3;Backing Up and Restoring Filegroups;109
9.4;Backing Up and Restoring Full- Text Indexes;114
9.5;Files/ Filegroups and Disaster Scenarios;115
9.6;Caveats and Recommendations;116
9.7;Summary;116
10;Creating a Backup/ Recovery Plan;117
10.1;Components of a Backup/ Recovery Plan;118
10.2;Key Business Constraints for BRPs;120
10.3;Key Technical Constraints for BRPs;126
10.4;SQL Agent;131
10.5;Base BRPs;142
10.6;Initial and Periodic Testing;155
10.7;Enhancing Basic Scenarios;156
10.8;Caveats and Recommendations;157
10.9;Summary;157
11;Maintaining a Warm Standby Server via Log Shipping;158
11.1;Log Shipping vs. Replication;159
11.2;Benefits of Log Shipping;160
11.3;Drawbacks of Log Shipping;163
11.4;Log- Shipping Architecture;165
11.5;Configuring Log Shipping;168
11.6;Caveats and Recommendations;189
11.7;Summary;190
12;Clustering;191
12.1;Clustering Basics;191
12.2;Sample Clustering Configurations;199
12.3;Failover in a Cluster;204
12.4;Failback in a Cluster;207
12.5;Clustering and Disaster Categories;208
12.6;Caveats and Recommendations;209
12.7;Summary;210
13;Database Mirroring;211
13.1;Mirroring Architecture;211
13.2;Mirroring Levels;222
13.3;Configuring Mirroring;227
13.4;Guidelines for Selecting a Database Mirroring Mode;239
13.5;Disaster Categories;241
13.6;Caveats and Recommendations;242
13.7;Summary;243
14;Database Snapshots;244
14.1;Understanding the Architecture;244
14.2;Creating Database Snapshots;246
14.3;Restoring Database Snapshots;248
14.4;Managing Database Snapshots;249
14.5;Using Database Snapshots to Address Process and User Error;253
14.6;Understanding Other Uses for Database Snapshots;254
14.7;Database Snapshots and Disaster Scenarios;255
14.8;Caveats and Recommendations;256
14.9;Summary;257
15;Hardware Considerations;258
15.1;Online Disk Storage;259
15.2;Archival Storage;273
15.3;Continuous Data Protection;274
15.4;Virtualization;274
15.5;Network Issues;275
15.6;Power;279
15.7;Heat;280
15.8;Hardware and Disaster Categories;281
15.9;Caveats and Recommendations;282
15.10;Summary;283
16;Disaster Recovery Planning;284
16.1;Putting It All Together;284
16.2;Real- World Scenarios;293
16.3;Recommendations and Caveats;306
16.4;Summary;306
17;Realistic Disaster Recovery Planning;307
17.1;Understanding Personality Archetypes;308
17.2;Overcoming Roadblocks;318
17.3;Caveats and Recommendations;332
17.4;Summary;333
18;SQL Server 2008 Considerations;334
18.1;Backup/ Restore Improvements;334
18.2;Database Mirroring Improvements;339
18.3;Change Tracking;340
19;Index;342