I run this command: DBCC CHECKDB WITH NO_INFOMSGS It cause tempdb full. Is there a way to prevent that? Thanks.
a9
2 楼
with no log?
【在 B*********L 的大作中提到】 : I run this command: : DBCC CHECKDB WITH NO_INFOMSGS : It cause tempdb full. : Is there a way to prevent that? : Thanks.
j*n
3 楼
use ESTIMATEONLY to see how big the size of tempdb is needed. consider increasing space of the tempdb when possible; otherwise consider separate checks instead of whole. such as NOINDEX, PHYSICAL_ONLY, DATA_PURITY. conduct BOL for more information.
【在 B*********L 的大作中提到】 : I run this command: : DBCC CHECKDB WITH NO_INFOMSGS : It cause tempdb full. : Is there a way to prevent that? : Thanks.
z*y
4 楼
dbcc checkdb use hell of space on tempdb. Don't know if there's way you can change this.
【在 j*****n 的大作中提到】 : use ESTIMATEONLY to see how big the size of tempdb is needed. : consider increasing space of the tempdb when possible; : otherwise consider separate checks instead of whole. such as NOINDEX, : PHYSICAL_ONLY, DATA_PURITY. conduct BOL for more information.
j*n
6 楼
It depends what's your major concern that you want to run this CHECKDB command. Can you describe in more detail? For example, if the major concern is about the consistency of disk space allocation structures, actually you may think only use the DBCC CHECKALLOC instead. Again, BOL is the best resource for reference.