HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Is there a Maintenance Plan that checks my database for corruption?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
checksdatabaseplanmaintenancethatfortherecorruption

Problem

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 ?

Solution

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



  1. Restore your db's on a test environment



  1. Run a dbcc checkdb on your databases.



This way you check your DB integrity and verify your backup.

Context

StackExchange Database Administrators Q#125859, answer score: 5

Revisions (0)

No revisions yet.