Research indexBook chapter
Database Consistency
Carter
Apress eBooks1 Jan 2015
NobleIDark:/48914/w1/20260525/9977F828DOI10.1007/978-1-4842-0710-9_8
Database Consistency
Carter · Apress eBooks · 2015 · Subscription
NobleIDark:/48914/w1/20260525/9977F828DOI10.1007/978-1-4842-0710-9_8
The full text is at the publisher
You can read the abstract here, or open it at the publisher.
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.