Post reply

dbcc checkdb increase log size

  • December 20, 2010 at 3:53 pm

    #104019

    Hi everybody,

    I want to know if a dbcc checkdb increases the database log file, cause a have a log shipping on SQL Server 2000 and it crashes after a database maintenance plan which does a dbcc checkdb, because the log file grows from 500 MB to 40000 MB, actually, the database size is 40000 MB.

    The database maintenance plan doesn´t rebuild indexes.

  • December 20, 2010 at 4:18 pm

    #1264842

    Hi John,

    While CHECKDB process is running, SQL Server keeps the information about the scanned portion of DB. This is to compare the information at one point with another point. SQL Server keeps these information in the memory in worktables. So if memory reaches its limit, these information will spill out to tempdb causing the tempdb to grow.

    You can estimate how much space tempdb will take for the CHECKDB operation of a database.

    DBCC CHECKDB WITH ESTIMATEONLY

    This code will only estimate.

    Thanks

    John

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

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