|
Pro SQL Server Disaster Recovery, Hardback
The process of disaster recovery involves mitigating the likelihood of a disaster and returning the system to a normal state. This book shows you how to implement an effective disaster recovery strategy for SQL Server 2005 databases. With the arrival of SQL Server 2005, you have access to enhanced existing features and powerful new tools, like database
snapshots and mirroring, for data backup and disaster recovery. The book also covers fundamental changes to disaster recovery capabilities, and common issues to expect when using new features.
The book examines the technical details of disaster recovery features, and then applies that information to practical scenarios. As businesses become increasingly reliant on the information they store in their various databases, effective data protection becomes ever more critical. Potential disasters can arise from natural causes, user errors, and media or hardware failure. This book will help you ensure that day - to - day activities can continue, regardless of the problem.
CONTENTS:
What Is Disaster Recovery?
Making Database Backups
Restoring a Database
Backing Up and Restoring Files and Filegroups
Creating a Backup/Recovery Plan
Maintaining a Warm Standby Server via Log Shipping
Clustering
Database Mirroring
Database Snapshots
Hardware Considerations
Disaster Recovery Planning
Realistic Disaster Recovery Planning
Appendix SQL Server 2008 Considerations
Index
|
