Category: FIND

DBCC VARIOUS OPTIONS

————-Find BAD PAGES with 823 or 824 error————— USE msdb GO SELECT * FROM dbo.suspect_pages ———DBCC TSQL ————————– dbcc checkdb WITH PHYSICAL_ONLY, ALL_ERRORMSGS, NO_INFOMSGS ———Progress of DBCC CheckDB—————- SELECT session_id , request_id , percent_complete , estimated_completion_time , DATEADD(ms,estimated_completion_time,GETDATE()) AS EstimatedEndTime, start_time , status ,command FROM sys.dm_exec_requests WHERE database_id = ‘XX’ — Spacify DB ID here
Read More »