Pro SQL Server Disaster Recovery / Edition 1

Hardcover (Print)
Buy New
Buy New from
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 97%)
Other sellers (Hardcover)
  • All (24) from $1.99   
  • New (11) from $1.99   
  • Used (13) from $1.99   


Many would argue that the single most important job of a SQL Server database administrator is to be able to recover your database in the event of loss or damage. Pro SQL Server Disaster Recovery helps you meet that goal by showing you how to think about and plan for potential problems. You’ll learn to anticipate and reduce the likelihood of a disaster, and to mitigate the effects of a disaster when one does occur. Perhaps most importantly, you’ll learn how to prepare so that you can return a system to its normal state quickly, ensuring system availability and the continued success and operation of your business.

Many SQL Server features and technologies are, or can be put to good use in disaster recovery planning. In this book, you’ll learn about powerful tools and features—such as Database Snapshots and Mirroring—for data backup and disaster recovery that are present in SQL Server 2005, and that are enhanced in SQL Server 2008. Also covered are common issues to expect when using these features. This book explores your options by examining the technical details of disaster recovery features and then applying that knowledge to practical scenarios.

There’s a human side to disaster recovery planning as well. Like few other activities, disaster recovery planning requires that you work closely with a wide variety of people from all across your organization. People skills are as critical to disaster recovery planning as technical skills, and perhaps more so. This book does not leave you in the dark, but provides sound advice on how to keep disaster recovery planning projects on track, how to avoid dangerous scope creep, and how to work effectively with the variety of personality types that you will encounter.

Disaster recovery planning is really about sleep. When you get the call at 3:00 am that your database is lost, don’t wake up with that icy feeling in your veins. Instead, wake up with confidence that you have a plan in place, a plan that you’ve practiced, that management has bought into, a plan that you can execute even while half–asleep to get your database, your company, and your job back on track.

What you’ll learn

This book shows you how to implement an effective disaster recovery strategy for SQL Server 2005 databases. It covers:

  • Real–world examples of data loss and what might have been done to prevent it
  • A systematic, problem–based approach to designing a disaster recovery plan
  • Pitfalls one might encounter, and how to deal with them
  • Team dynamics, and the soft–side of disaster planning
  • New technology in SQL Server 2005 and 2008 that takes disaster recovery beyond the simple backup/recovery plan
  • When and why to use disaster recovery features, as opposed to just describing how they work

Who this book is for

SQL Server database administrators.

Read More Show Less

Product Details

  • ISBN-13: 9781590599679
  • Publisher: Apress
  • Publication date: 3/28/2008
  • Series: The Expert's Voice in SQL Server Series
  • Edition description: 2008
  • Edition number: 1
  • Pages: 350
  • Product dimensions: 0.76 (w) x 7.00 (h) x 10.00 (d)

Meet the Author

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.
Read More Show Less

Table of Contents

Ch. 1 What Is Disaster Recovery? 1

Ch. 2 Making Database Backups 13

Ch. 3 Restoring a Database 43

Ch. 4 Backing Up and Restoring Files and Filegroups 75

Ch. 5 Creating a Backup/Recovery Plan 99

Ch. 6 Maintaining a Warm Standby Server via Log Shipping 141

Ch. 7 Clustering 175

Ch. 8 Database Mirroring 195

Ch. 9 Database Snapshots 229

Ch. 10 Hardware Considerations 243

Ch. 11 Disaster Recovery Planning 269

Ch. 12 Realistic Disaster Recovery Planning 293

App SQL Server 2008 Considerations 321

Index 329

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)