Davis / Simmons Pro SQL Server 2008 Mirroring

1. ed
ISBN: 978-1-4302-2424-2
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 400 Seiten

Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option. Mirroring protects you by maintaining one or more duplicate copies of your database for use in the event the primary copy is damaged. It is a key component of any production-level, high-availability solution. This book covers the full spectrum of database mirroring, taking you from the planning phase through the implementation to the maintenance phase and beyond. Easy to follow, step-by-step instructions for beginner and intermediate users In-depth, detailed information for advanced and expert users Covers all phases of database mirroring from planning to sustained maintenance

Robert L. Davis is a database administrator and data architect consulting at Microsoft who has worked extensively in setting up and creating automated processes to manage database mirroring for many internal Microsoft applications. He additionally consults with various internal Microsoft IT groups to assist them with their database mirroring needs. Robert is currently working on the Architecture & Performance Engineering team of the CAP application program group. CAP is the internal software used by support personnel for all of Microsoft's customer facing products such as Xbox, Zune, MSN, Microsoft Live, and HotMail. He has over eight years of SQL Server administration experience, much of that in high-availability environments. Rob writes frequently about mirroring and related topics in his blog: www.sqlservercentral.com/blogs/robert_davis/default.aspx

Autoren/Hrsg.

Davis, Robert

Simmons, Ken

Inhaltsverzeichnis

1;Contents at a Glance;4
2;Contents;5
3;About the Authors;13
4;About the Technical Reviewer;14
5;Introduction;15
5.1;Who This Book Is For;15
5.2;How This Book Is Structured;15
5.3;Prerequisites;16
5.4;Downloading the Code;16
5.5;Contacting the Authors;16
6;High-Availability Options;17
6.1;High Availability vs. Disaster Recovery;17
6.2;Database Mirroring;18
6.3;Failover Clustering;18
6.4;Log Shipping;20
6.5;Replication;22
6.6;Comparing High-Availability Features;23
6.7;Designing a Complete High-Availability Solution;24
6.8;Summary;26
7;Database Mirroring Overview;27
7.1;Defining Key Terms;27
7.2;Choosing an Operating Mode;28
7.3;Understanding Sessions;33
7.4;Understanding Mirroring States;34
7.5;Switching Roles;36
7.6;Transparent Client Redirection;36
7.7;Enhanced Features;36
7.8;Features by Edition;38
7.9;Summary;38
8;Planning and Best Practices;39
8.1;Step One: Know Your Environment;39
8.2;Step Two: Know Your Applications;41
8.3;Step Three: Know Your Plan;43
8.4;Sample Plan;43
8.5;Best Practices;44
8.6;Summary;46
9;Database Mirroring Setup;47
9.1;Before You Begin;47
9.2;Following the Wizard;49
9.3;Setting Up Mirroring Manually;59
9.4;Special Case: Mirroring with Certificates;63
9.5;Test, Monitor, and Wrap Up;65
9.6;Troubleshooting Common Setup Issues;66
9.7;Summary;68
10;Automating Setup;69
10.1;Prepare the Database for Mirroring;69
10.2;Back Up the Principal Database;71
10.3;Restore Full Backup on the Mirror Database with No Recovery;76
10.4;Back Up the Log of the Principal Database;80
10.5;Restore the Log on the Mirror Database with No Recovery;80
10.6;Create Endpoints on Instances;81
10.7;Create Login for the Service Accounts and Grant Connect;83
10.8;Set the Mirroring and Witness Partners;85
10.9;Change the Operating Mode If Not Using a Witness;88
10.10;The Master Procedure;90
10.11;Alternative Setup Using PowerShell;98
10.12;Summary;110
11;Maintenance Simplified;111
11.1;Routine Maintenance Considerations;111
11.2;Transaction Log Backups;111
11.3;Log File Size;126
11.4;Routine Patching and SQL Server Upgrades;131
11.5;Fail Back to the Original Principal;133
11.6;Setting Database Owner and TRUSTWORTHY Property;135
11.7;Controlled Failover of Mirrored Databases;137
11.8;Automatic Failover of Mirrored Databases;145
11.9;Summary;157
12;Monitoring and Alerting;158
12.1;Monitoring Components;158
12.2;Understanding Warning Thresholds;160
12.3;Using the Database Mirroring Monitor;161
12.4;Using System Stored Procedures;167
12.5;Understanding Performance Counters;172
12.6;Configuring Database Mail;174
12.7;Creating Alerts;177
12.8;Useful Views;183
12.9;Using the State Change Trace Event;184
12.10;Summary;185
13;Upgrading to SQL Server 2008;186
13.1;Using the Upgrade Advisor;186
13.2;Upgrade Strategies;195
13.3;Performing an In-Place Upgrade;196
13.4;Minimizing the Downtime of a Side-by-Side Upgrade;199
13.5;Post-Upgrade Procedures;200
13.6;Summary;202
14;Reporting Considerations;203
14.1;Using Database Snapshots;203
14.2;Using Log Shipping;209
14.3;Using Replication;213
14.4;Summary;221
15;Planning for Failure;223
15.1;Detecting Errors;223
15.2;Failure Scenarios;225
15.3;Failover Considerations;234
15.4;Planning and Research;237
15.5;Microsoft Support Options;239
15.6;Summary;240
16;Index;241