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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Rights and permissions
Copyright information
© 2015 Peter A Carter
About this chapter
Cite this chapter
Carter, P.A. (2015). Backups and Restores. In: Pro SQL Server Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0710-9_15
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0710-9_15
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0711-6
Online ISBN: 978-1-4842-0710-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books