All Questions
Tagged with dbcc-checkdb jobs
5 questions
0
votes
1
answer
754
views
DBCC CHECKDB job failed on SQL Server 2014
We have a DBCC CHECKDB job that runs weekly on Saturdays. This job was created thorugh Maintenance Plan wizard. Typical duration for this job is 1.5 hours. This past weekend the job failed with the ...
- 83
-3
votes
1
answer
1k
views
SQL Server Integrity Check error
I’ve Implemented Ola's SQL Server Integrity Check on one of my SQL 2012 Servers and created a SQL Agent job to run it.
The job fails every time I run it, but when I run the code below manually it ...
- 11
2
votes
1
answer
2k
views
dbcc failing with Cannot continue the execution because... alwayson having a change of state event for each db
I got a job DatabaseIntegrityCheck - USER_DATABASES, failing with the following error:
Date and time: 2018-10-29 02:34:13 Command: DBCC CHECKDB ([one of my
databases]) WITH NO_INFOMSGS, ...
- 16.6k
1
vote
0
answers
197
views
How to verify DBCC CHECKDB
I am logging the DBCC CHECKDB job output to a table.
When I look at the job log using the below command, I want to verify that all is well.
use msdb
EXEC dbo.sp_help_jobsteplog
@job_name = N'...
- 501
2
votes
3
answers
518
views
Dumps after CHECKDB error
I have a little problem with a two-node mirror and customer requirements:
There is a maintenance window every night from 01:30 to 03:00, within which I have to run rebuild/reorg and checkdb (...
