Home Forums SQLServerCentral.com Editorials Checking CHECKDB RE: Checking CHECKDB

  • May 22, 2018 at 1:15 pm

    #1991498

    Eric M Russell - Tuesday, May 22, 2018 7:24 AM

    .. The problem is that for many of us, we may run DBCC CHECKDB on another machine, perhaps on a restored copy of production, so how can we track this? ..

    The default trace logs DBCC CHECKDB events.

    It does, true, but the question raised in the article is, if you run CHECKDB against a copy, how does someone else know you ran it against that DB if they're checking production?  How do you somehow transfer the results from the copy to production?

    If you're on SQL2016 SP1, you can't update the property (DatabasePropertyEx() -> LastGoodCheckDbTime) so how would you do it?