Posted on 2006-06-26
Since we been using SQL 2000 to host our DB, I have never used the maintenance plan wizard. I've just created a job to perform the full backups every night.
Our developers have recommended to run a maintenance plan to perform the optimize job & integrity check against the production DB.
The integrity check failed when I tried to run it for the 1st time over the weekend, saying "Database needs to be in single user mode." I had the "attempt to repair any minor problems" selected. Is it recommended to select this ? If so, is there any other way of running this job without scripting it ?
Also is it essential to backup the database as part of the maintenance plan ?