Abstract
The ability to restore databases in SQL Server 2012 is essential to recovering a system when catastrophes arise. In order to restore your databases, you need a backup strategy that fulfills the requirements set forth by your business requirements. If your backup strategy is inadequate, then you will not be able to recover to the predetermined interval required to fulfill the requirements of your application. Ultimately, your application will lose data, and the users and your management will be very unhappy. In the last chapter, we covered the details of creating effective and efficient backup strategies. This chapter will focus on the skills needed to restore a database when the time arises.
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
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Ken Simmons and Sylvester Carstarphen
About this chapter
Cite this chapter
Simmons, K., Carstarphen, S. (2012). Restore and Recovery Strategies. In: Pro SQL Server 2012 Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3916-1_11
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3916-1_11
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3915-4
Online ISBN: 978-1-4302-3916-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books