HildaJ (8/13/2013)
However, if I removed this option how am I suppose to repair any errors if found? I guess manually?
By restoring a clean backup. Repair is usually a last resort when you don't have backups and it does just about nothing on master anyway as repair doesn't fix system tables.
How do you know your backups (of master) are good? Been restoring them and running checkDB on the restored copy? If not, then you have no guarantee those backups are even usable.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability