Job 'IntegrityCheck' failed

Question

Hello.
I am doing log shipping transaction from one primary database to 2 different secondary databases.
Then every morning I validate success by running the query (see attachment). My script checks that value of 'last_run_outcome' equal 1
I noticed that the value for Job 'IntegrityCheck' is 0.
I ran 'DBCC CHECKDB' against database and it completed successfully.
My question: could I disregard this failure in my query or need to troubleshoot?

Thanks51303-job-result.txt

Answer 1

So just above the error message about DBCC terminating abnormally, I see this being logged 80 ms earlier:

Setting database option SINGLE_USER to ON for database 'app4_starlims_data_c2'.

Assuming that this is done with ROLLBACK IMMEDIATE, this explains why DBCC terminated. I also made a test and verified that this operation results exactly in this message in the errorlog.

You talk about restore - you can of course not restore a database and the same time run DBCC on the database.

I checked that we set option 'disconnect' other users while restore database.

That is unlikely to be the correct action. The correct action would be to reschedule the job so that the RESTORE runs and completes before DBCC. There is little point in running on DBCC on something you will throw away just a few minutes later.

Answer 2

Well today is first time when I did not get error.
We set to restore every 2 hours starting from midnight. Restore takes around 10 minutes.
For now I will keep it 'disconnect from other users' i.e. in a single-user mode. It worked today hence I will monitor it for some while. In case it fail again .. I will reschedule restore operation.
Thanks a lot for your advice.