Click here to monitor SSC
  • Av rating:
  • Total votes: 38
  • Total comments: 2

SQL Backup and Restore

26 March 2012
SQL Server Backup and Restore by Shawn McGehee

Free eBook download
Buy the printed book: US $29.99 | UK £19.99

"The ability to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster, can mean the mean the difference between life or death for a business, and for the career of a DBA. This, in essence, is the critical importance of database backup and restore" – Shawn McGehee.

SQL Server Backup and Restore

By Shawn McGehee; 10-chapter, 300 page eBook plus paperback

Sign up for eBook updates

Simple-talk will not share this email address with external parties, under any circumstances, and we'll only use it to send emails directly related to this book (unless you used the same address to register for another of our newsletters).

Table of Contents

  • Ch01: Basics of Backup and Restore
  • Ch02: Planning, Storage and Documentation
  • Ch03: Full Database Backups
  • Ch04: Restoring from Full Backups
  • Ch05: Log Backups
  • Ch06: Log Restores
  • Ch07: Differential Backup and Restore
  • Ch08: Backup and Restore with SQL Backup
  • Ch09: File Backup and Restore
  • Ch10: Partial Backup and Restore

About the Book

The duties and responsibilitie:s of a Database Administrator (DBA) make for long and dynamically changing list, ranging from offering query tuning advice, to cutting stored procedures, all the way through to system process design and implementation for high availability. A DBA's tasks, from day-to-day, are rarely constant; with one exception: the need to ensure each and every day that any database in their charge can be restored and recovered, in the event of error of disaster. This means that if a database, for whatever reason, gets corrupted, dropped, or otherwise becomes unusable, then it is the DBA's responsibility to restore that database to the state it was in before the problem occurred, or as close as is possible.

Of course, this doesn't mean that a DBA is required to restore a database each and every day, just that if disaster does strike the DBA must be prepared to deal with it, regardless of when or why it occurs. If a DBA isn't prepared, and significant data is lost, or databases become unavailable to end users for long periods of time, then that DBA probably won't be in their job for too long. This is why a good, and tested, SQL Server backup and restore plan must be on the top of every administrative DBA's list of tasks.

In this book, you'll discover how to perform each of these backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool. Capturing backups using SSMS or simple scripts is perfectly fine for one-off backup operations, but any backups that form part of the recovery strategy for any given database must be automated and you'll also want to build in some checks that, for example, alert the responsible DBA immediately if a problem arises. The tool of choice in this book for backup automation is Red Gate SQL Backup. Building your own automated solution will take a lot of work, but we do offer some advice on possible options, such as PowerShell scripting, T-SQL scripts and SQL Server Agent jobs.

Shawn McGehee

Author profile:

Shawn McGehee is a DBA living in Orlando, FL. He has been working in IT since graduating high school in 1997, in positions ranging from web developer, to help desk operative, to his current position as a Senior DBA. He is heavily involved in the SQL Server community, speaking at and organizing local users groups in Florida since 2008, and is currently President of the OPASS group in Lake Mary, FL.

Search for other articles by Shawn McGehee

Rate this article:   Avg rating: from a total of 38 votes.





Must read
Have Your Say
Do you have an opinion on this article? Then add your comment below:
You must be logged in to post to this forum

Click here to log in.

Subject: Thanks
Posted by: belzaleel (view profile)
Posted on: Sunday, June 17, 2012 at 10:05 PM
Message: Regards for this Books.

Subject: a very useful book for DBA
Posted by: dheerajjoshi (view profile)
Posted on: Friday, October 26, 2012 at 4:08 AM
Message: It's a very nice book with a lot of useful information.


Recommended site is a user-driven wiki which provides .NET developers with native method signatures, so they don't have to spend time writing them from scratch.

Check out!

Top Rated

SQL Server Source Control Basics
 For efficient team-based database development, and reliable and repeatable database deployments, source... Read more...

Tribal SQL
 Tribal SQL, is a reflection of how a DBA's core and long-standing responsibilities sit alongside new... Read more...

Book Review: Optimizing And Troubleshooting Hyper V Networking 2013
 If you want to learn how to optimize and troubleshoot Hyper-V, then this book, written by Microsoft... Read more...

Don't Just Roll the Dice - eBook Download
 Neil Davidson has created a short handbook with the theory, practical advice and case studies, to... Read more...

Captain Biplane: Interplanetary Airman
 Simple-Talk caters for the lighter side with its publication of 'Captain Biplane: Interplanetary... Read more...

Most Viewed

Troubleshooting SQL Server: A Guide for the Accidental DBA
 Three SQL Server MVPs, and stalwarts of the SQLServerCentral and MSDN community forums, provide... Read more...

Exchange 2010 - A Practical Approach
 Jaap's Practical Guide to Exchange Server 2010 draws upon all that experience to deliver an easy-to-use... Read more...

Brad's Sure Guide to SQL Server Maintenance Plans
 Brad's Sure Guide to Maintenance Plans shows you how to use the Maintenance Plan Wizard and Designer to... Read more...

SQL Server Hardware
 SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent... Read more...

Inside the SQL Server Query Optimizer
 This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the... Read more...

Why Join

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.