Following on from my Blog on SQL Server Agent for SQL Server 2005 Express, this post is to run you through having confidence in the integrity of your databases. This is blog 2 of 3 on Database Maintenance in SQL Server 2005 Express.
Database Integrity is the process of checking your logical and physical integrity of all of your objects in your database. To achieve this you utilise the command DBCC CheckDB which performs the following checks:·
You want to run this check prior to running your backups as discussed in Database Maintenance In SQL Server 2005 Express – Recoverability. If your database does have issues then you should be notified about this and resolve the issues prior to running your database backup. Otherwise you could potentially be backing up a corrupt database, that in the event of an issue and your needing to restore your database you could find yourself in the position of performing a restore of an invalid database.
Feel free to download usp_CheckDB.sql to perform your Integrity checks.
Stay tuned for the next installment in Database maintenance in SQL Server 2005 Express – Performance