Looking for verification here please :-
Propose setting up SQL Maintenance plan on our two servers as follows :-
1. Weekly run DBCC check
2. Monthly rebuilt indexes
The backups on all content DBs are nightly, and all System DBs weekly. I have a couple of questions :-
1. When you run the DBCC check through a maintenance plan, if there are issues where are these output to ? Should you therefore run this, then check the output, then run Repair (if necessary) or should you run the DBCC check and LINK it to DBCC repair to run only after successful run of the first part - or should you simply run with the repair option ONLY ?
2. If the databases are synchronously mirrored, will any changes need to be made to the proposed plan (I am thinking here that there would be no need to backup anything on the secondary mirrored copy as this will be in sync, but also, are there any extra/different recommended practices when using mirroring ?)