HAPPY HOLIDAYS: Get a special discount on Apress Access! Subscribe today >>

Pro SQL Server Disaster Recovery

Authors: Luetkehoelter, James

Download source code
  • First book to market on one of the most crucial topics for today's business and corporations
  • Covers all new 2005 and 2008 features, with broad appeal to users of SQL Server 2000 on up as well as third-party database users
  • Written by an acknowledged expert in the field who has high community recognition
see more benefits

Buy this book

eBook $59.99
price for USA
  • ISBN 978-1-4302-0601-9
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Hardcover $74.99
price for USA
  • ISBN 978-1-59059-967-9
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

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.

About the authors

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.

Table of contents (12 chapters)

Buy this book

eBook $59.99
price for USA
  • ISBN 978-1-4302-0601-9
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Hardcover $74.99
price for USA
  • ISBN 978-1-59059-967-9
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Pro SQL Server Disaster Recovery
Authors
Copyright
2008
Publisher
Apress
Copyright Holder
James Luetkehoelter
eBook ISBN
978-1-4302-0601-9
DOI
10.1007/978-1-4302-0601-9
Hardcover ISBN
978-1-59059-967-9
Edition Number
1
Number of Pages
XXIV, 342
Topics