patternMinor
Is there a Maintenance Plan that checks my database for corruption?
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
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
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:
This way you check your DB integrity and verify your backup.
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:
- Backup your databases
- Restore your db's on a test environment
- Run a
dbcc checkdbon 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.