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 ?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Good question. The integrity check in the maintenance plan is enough since it will run a
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
This way you check your DB integrity and verify your backup.
@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.