Buy Used
CDN$ 4.64
+ CDN$ 6.49 shipping
Used: Acceptable | Details
Condition: Used: Acceptable
Comment: Ships from the USA. Please allow 2 to 3 weeks for delivery. Ex-Library Book - will contain Library Markings. Millions of satisfied customers and climbing. Thriftbooks is the name you can trust, guaranteed. Spend Less. Read More.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

SQL Server Backup and Recovery: Tools and Techniques Paperback – Dec 3 2001

4.4 out of 5 stars 5 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
"Please retry"
CDN$ 30.62 CDN$ 4.64

Harry Potter and the Cursed Child
click to open popover

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Product Details

  • Paperback: 320 pages
  • Publisher: Prentice Hall; 1 edition (Dec 3 2001)
  • Language: English
  • ISBN-10: 0130622982
  • ISBN-13: 978-0130622983
  • Product Dimensions: 23.3 x 17.7 x 2.2 cm
  • Shipping Weight: 544 g
  • Average Customer Review: 4.4 out of 5 stars 5 customer reviews
  • Amazon Bestsellers Rank: #3,560,914 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description

From the Back Cover

Microsoft SQL Server backup: in-depth, start-to-finish, for every DBA!

  • The most complete guide to SQL Server 2000 backup and recovery!
  • Step-by-step coverage for backing up and restoring your databases, log shipping, and proper DBCC usage
  • Making the most of factory-delivered SQL Server backup, restore and diagnostic tools
  • Includes coverage of SQL Server in Windows(r) environments for XP and 2000
  • Contains scripts and sample code for streamlining backup and recovery!

Written by a Microsoft senior consultant who specializes in SQL Server enterprise deployments, SQL Server Backup and Recovery is a comprehensive guide to protecting and restoring SQL Server databases. The book is organized to serve as both a hands-on tutorial and a long-term reference. Coverage includes:

  • What every DBA needs to understand about SQL Server backup and recovery architecture and algorithms
  • Planning for backup and recovery: time windows, recovery scenarios, and backup strategies
  • Making the most of SQL Server's built-in backup and recovery and diagnostic tools
  • Recovering the master database, step by step
  • Installation and role changing with log shipping
  • How to properly use SQL Server's DBCC commands

SQL Server Backup and Recovery contains scripts and sample code designed to automate and streamline the backup and recovery process—tools field-proven in enterprise deployments. If you're responsible for protecting the data in a Microsoft SQL Server database, this is the realistic, systematic guide you've been searching for!

About the Author

FRANK McBATH is an SQL Server specialist in Microsoft's Enterprise Applications Practice specializing in architecting and implementing large database installations. Before joining Microsoft, McBath worked for several Fortune 100 firms and consulting houses.

See all Product Description

Customer Reviews

4.4 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See all 5 customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
McBath's book highlights common problems and provides practical workarounds for Backup/restore
The Book shows some very cool tricks that make it possible to recover data that's lost due to media
failures. It also covers data recovery tricks by using indexes. It continues about explaining what
to do when you need to rebuild your machine from scratch. Common problems are discussed and workarounds
given. The book is full of examples and tips and tricks from REAL consulting, not rehashing a manual
or Books on line. These tips give the book even more value.
What I liked most was that it describes using the GUI and T-SQL scripts. A GUI is nice but to really
hit the nail one should automate this and script it.
This is THE Backup/Restore book each SQL-Server DBA must have in his bag. READ it BEFORE disasater
happens. One can never be preperaed enough for situations like this.
Last but not least there's an appendix with the Mohan/Narang paper This paper outlines
the ARIES Write Ahead Log protocol recovery mechanism that SQL Server uses.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse
Format: Paperback
Just got back from the book store and spent a bit reading this book. It's actually quite good. McBath makes the assumption that you are a DBA. Not someone who reads Gartner reports and goes to meetings.
I've become accustomed to a wide variety of lame backup and recovery books. A good example is Anil Desai's... long on planning, but short on how to actually do the work. In his book, backups don't actually start till chapter 6! Easily 2/3 of the book is fluff.
For example, Desai talks about log shipping-- 5 pages. McBath has a whole chapter on it in a how-to format. BOL doesn't cover it in depth, and where it does, it's wrong (ie. sp_change_primary_role example is wrong on fail over). SQL Server Resource Kit has a whole chapter on it, but not one example of how to implement. Long on theory, short on getting it done-- typical of MS Press books.
The book covers just about all the methods for backing up and recovery using standard tools. It also covers using DBCC to recovery data. Then it expands out into rebuilding your stuff from scratch and reloading it (ex. I lost my master database and here's what I got to do).
McBath's book tells you what breaks along the way and how to fix it. Anyone who's had to rebuild master and got in that infinite loop problem knows the hard way. McBath tells you about the problem *BEFORE* you hit it and how to work around it. The Desai book doesn't even tell you how to properly bring the SQL Server into single user.
This is also the only book out there... including Delaney's... that actually flow charts the sequence of events on how a backup and recovery actually work internally. LSN's, GAM Pages, etc... That way you get the theory as well as the practical I-got-to-get-my-job-done stuff.
Read more ›
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse
Format: Paperback
Author calls it concise monograph that covers a wide variety of backup and recovery issues with plenty of examples. Well, concerning backup section there are more examples in Books on Line. No backup options are explained (i.e. You would use this option to do this particular thing). Absolutely NO scenarios are given. Only a few basic backup statements without any explanation what to run before and after backup. There is an interesting script "Monitoring the Completion of a Backup" - almost 3 pages of code but there is no download option so it is up to the reader to type it in. What a waste of time. Author often makes a point how bad backup and restore practices are in places he did the consulting for. I think they are no better or worse than the books we have to learn from.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse
Format: Paperback
If you do any SQL Server administration where your boss cares about the data contained therein, TRUST ME, READ THIS BOOK THOROUGHLY BEFORE you are in a position of responsibilty. Had I never read this book before I inherited my DBA responsibilities, I doubt I'd be employed right now. This book could not be easier to read, have better examples or provide better insights. Even though I went through a MOC training course and the teacher was great, one week isn't long enough for everything to sink in. Thank goodness there are guys like Mr. McBride to fill in the remaining gap.
I could not say enough good things about this book...mainly becuase I still have a good job because of it.
If your database is important to your boss, this book is a MUST!!!!!!!!!!!
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse
Format: Paperback
Frank McBath has successfully filled a gap in the reference book section with this complete guide to SQL Server 2000 Backup and Recovery. With its in-depth content and real world examples, McBath's book provides a comprehensive look at everything you will need to know about SQL Server backup and recovery. He highlights common problems and provides practical workarounds. One of the great things about this book is that it is not so general that you would be hard-pressed to find useful examples. McBath gives you the commentary, the code and the specific content that you can use at work. This is definitely the kind of book that every SQL Server DBA should have!
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse