Post reply

data file .mdf datetime stamp on windows file system when running DBCC CheckDB

  • August 1, 2019 at 8:30 pm

    #3668046

    I'm trying to find out what causes the timestamp to change on the data file when running DBCC CheckDB.  I have confirmed that auto grow, auto shrink, open, close or a restart did not occur.

    What exactly would DBCC CheckDB be doing that it would need to change the date timestamp on the data file?

  • August 1, 2019 at 9:10 pm

    #3668058

    I think it's creating internal database snapshot to run checks against.

    --Vadim R.

  • August 2, 2019 at 8:49 pm

    #3668398

    Any activity for the database should change the timestamp. DBCC does create a snapshot, which I'm guessing marks some sort of item in the file.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply