• I have a database back up job with one step and the command:

    BACKUP DATABASE [myDBName] TO DISK = N'F:\myDBName' WITH INIT , NOUNLOAD , NAME = N'myDBName backup', NOSKIP , STATS = 10, NOFORMAT

    I don't do anything else ...

    In SQL 2000, how can I see if "automatically fix minor problems" is checked?

    Does "DBCC CheckDB" only check the database and not fix it? How long will it take to run? Will shrinking the database more help (log and data files)?