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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Peter A. Carter
About this chapter
Cite this chapter
Carter, P.A. (2019). Backups and Restores. In: Pro SQL Server 2019 Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5089-1_12
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5089-1_12
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5088-4
Online ISBN: 978-1-4842-5089-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books