There is no mystery, the 2 messagges for CellTestData_QC
reference 2 different databases CellTestData_QC
.
The first one is your database CellTestData_QC
on your server (server A
), on this databasewhich DBCC CHECKDB
did not complete because you began a restore
.
The second message refers to the restored database CellTestData_QCCellTestData
from. It's not serverDBCC BCHECKDB
that was running on 25/01, it's just an info that is stored within CellTestData
, and it reports the last date when DBCC CHECKDB
completed without errors on this database.
Every time the database is opened (goes online
), the last known good-known dbcc checkdb
date is reported in eroor log
. So the second message tells you that DBCC CHECKDB completed successfully on your database on server BCellTestData
on 2019-01-24 23:01:46.507
. This message appears in error log
as soon as restore
is completed.
You can see this on every server restart. SQL Server
opens every database that should go online
and within every database it reads the date called last known good time
and reports it in errorlog
. This does not mean that checkdb
runs on every restart, in fact, the date reported is always earlier than the current date.
For example, if you run checkdb
every Sunday, and the restart occurs on Saturday, you'll see these messages reporting previous Sunday date in errorlog
as it was the last date when dbcc checkdb
completed successfully.
Here CHECKDB From Every Angle: When did DBCC CHECKDB last run successfully? you can read more on last-known good time
.