I have another question about checkdb. I just started at a new employer and am wondering about a nightly job that I found. Here's the only thing in it:
dbcc checkdb (dbname) with no_infomsgs.
If you run the checkdb command without any repair arguments, does it actually DO anything to the database? Is it correct to say that without a repair argument, it's only going to provide information?
What benefit would there be from running this with no_infomsgs on a nightly basis? And if even if I left off that argument, what benefit would there be to running it as nightly job? Does it write the checkdb results to the log?