Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Configuring SQL server storage architecture for quick recovery


In continuation of the previous recipe, the storage server configuration helps the data platform to keep up the scalability. Similarly, the storage architecture can also help to attain the quick recovery of data in case of failure.

Business-critical applications depend on SQL Server and its features maintain the data integrity as well as ensure data availability and performance, which requires the storage architecture to store data on high-performance and highly available storage resources.

In this recipe, we will go through the guidelines to be followed in configuring SQL Server storage architecture for quick recovery. The default features from Windows operating system Volume Shadow Copy Services (VSS) supports the SQL Server database backup and recovery to simply the data protection to ensure the high availability. The data protection strategy must be based on a recovery point and time objectives by keeping five 9s (99.999 percent...