December 20, 2010 at 3:53 pm
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
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