Skip to main content
added 952 characters in body
Source Link
sepupic
  • 11.2k
  • 17
  • 27

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.

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 database DBCC CHECKDB did not complete because you began a restore.

The second message refers to the restored database CellTestData_QC from server B.

Every time the database is opened (goes online), the last 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 B on 2019-01-24 23:01:46.507. This message appears in error log as soon as restore is completed.

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 which DBCC CHECKDB did not complete because you began a restore.

The second message refers to the restored database CellTestData. It's not DBCC CHECKDB 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 dbcc checkdb date is reported in eroor log. So the second message tells you that DBCC CHECKDB completed successfully on your database CellTestData 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.

Source Link
sepupic
  • 11.2k
  • 17
  • 27

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 database DBCC CHECKDB did not complete because you began a restore.

The second message refers to the restored database CellTestData_QC from server B.

Every time the database is opened (goes online), the last 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 B on 2019-01-24 23:01:46.507. This message appears in error log as soon as restore is completed.