Backups and Restores

  • Peter A Carter

Abstract

Backing up a database is one of the most important tasks that a DBA can perform. Therefore, after discussing the principles of backups, we look at some of the backup strategies that you can implement for SQL Server databases. We then discuss how to perform the backup of a database before we finally look in-depth at restoring it, including restoring to a point in time, restoring individual files and pages, and performing piecemeal restores.

Keywords

Recovery Model Backup Copy Address Table Context Menu Backup Strategy 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Supplementary material

978-1-4842-0710-9_15_MOESM1_ESM.zip (7 kb)
978-1-4842-0711-6_CH15.zip (zip 8 kb)

Copyright information

© Peter A Carter 2015

Authors and Affiliations

  • Peter A Carter
    • 1
  1. 1.BotleyUK

Personalised recommendations