Is there any way to make a maintenance plan check all my databases on a single instance?
Is the maintenance plan Check Database Integrity Task
enough ?
SQL Server Maintenance Plan – How to Check Database for Corruption
corruptionmaintenancemaintenance-planssql-server-2008sql-server-2008-r2
Related Question
- SQL Server – Restore Database Maintenance Plan Task
- SQL Server – TempDB Not Selectable for DBCC Maintenance Plan
- Sql-server – How to know that , Is it Maintenance Cleanup Task is working properly from maintenance Plan or not through T-SQL
- SQL Server Backup – Backing Up Multiple Instance System Databases with Distributed Maintenance Plan
- Sql-server – Maintenance plan fails on non-existent database
- Sql-server – How to share values in maintenance plan tasks
- Creating a Maintenance Plan for a SQL Azure Database
Best Answer
Good question. The integrity check in the maintenance plan is enough since it will run a
dbcc checkdb
. From MSDN:integrity check
Running this task will be resource intensive. You don't want to do this in prod. servers if you don't have a maintenance window.
The common way is the following:
1. Backup your databases
2. Restore your db's on a test environment
3. Run a
dbcc checkdb
on your databases.This way you check your DB integrity and verify your backup.