August 21, 2019 at 6:31 am
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?
August 21, 2019 at 12:02 pm
(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
August 22, 2019 at 6:36 am
(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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply