Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 ?

share|improve this question
up vote 4 down vote accepted

Good question. The integrity check in the maintenance plan is enough since it will run a dbcc checkdb. From MSDN:

integrity check

The Check Database Integrity task encapsulates the DBCC CHECKDB statement.

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.

share|improve this answer

@RayofCommand, has already given an appropriate answer, but will like to add more which is very helpful and easy to track for any corrupt databases using SQL Server Integrity Check from ola hallengren.

Is the maintenance plan Check Database Integrity Task enough ?

  1. Well, for this should check some more details on this as explained by Kendra on DBCC CheckDB FAQ: Check for Corruption in SQL Server

  2. You should also set alerts fro any corruption as a proactive alerts as explained here

  3. Last but not least, please refer to this great blog post from @Aaron Minimizing the impact of DBCC CHECKDB : DOs and DON'Ts..

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.