Abstract
Databases involve lots of IO. When you have a lot of IO, you inherently run the risk of corruption. Your primary defense against database corruption is to take regular backups of your database and to periodically test that these backups can be restored. You need to look out for database corruption, however, and SQL Server provides tools you can use to check the consistency of your database, as well as to resolve consistency issues if backups are not available. This chapter will look at the options you have for both checking and fixing consistency issues.
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
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). Database Consistency. In: Pro SQL Server Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0710-9_8
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0710-9_8
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