Abstract
Chapter 8 introduced the concept of backing up your database. Making a copy of the database and storing it separately from the original database is a wonderful safety mechanism. But it’s an incomplete model. After you back up the database, you need to be able to bring it back and put all the structures and data from the backup onto your server for use again. This is known as a restore. Restoring a database is every bit as important as backing up the database. Without the backup, you have nothing to restore, but unless you can restore, you might as well have skipped the backup. There’s an old saying, “your backups are only as good as your last restore.”
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Rob Walters, Grant Fritchey
About this chapter
Cite this chapter
Walters, R., Fritchey, G. (2012). Database Restore Strategies. In: Beginning SQL Server 2012 Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3982-6_9
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3982-6_9
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3981-9
Online ISBN: 978-1-4302-3982-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books