CHECKDB

  • VastSQL

    SSC-Dedicated

    Points: 35725

    My user database drive have about 100GB free space now and the database is about to reach 120GB, will this cause my CHECKDB job to fail ?

    I am using Ola's maintenance plan, is there any work around for this like creating DB snapshot manually?

  • John Mitchell-245523

    SSC Guru

    Points: 148306

    (1) Not necessarily.  DBCC CHECKDB creates an internal snapshot of the database.  Database snapshots are sparse files, so they start off at (near) zero size and only grow when data pages in the source database change.  If you run DBCC CHECKDB at a quiet time (and certainly avoid the index maintenance window), disk space is unlikely to be a problem for you

    (2) No.  You can't configure the location of the internal snapshot

    John

  • VastSQL

    SSC-Dedicated

    Points: 35725

    John Mitchell-245523 wrote:

    (1) Not necessarily.  DBCC CHECKDB creates an internal snapshot of the database.  Database snapshots are sparse files, so they start off at (near) zero size and only grow when data pages in the source database change.  If you run DBCC CHECKDB at a quiet time (and certainly avoid the index maintenance window), disk space is unlikely to be a problem for you

    (2) No.  You can't configure the location of the internal snapshot

    John

    Thanks a lot John

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

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