Warning 164?

navillus

A few days ago I started receiving the following warning on backups of certain databases:

11/20/2017 10:43:59 AM: Warning 164: Failed to delete backup entries in msdb tables: SQL error 208: Invalid object name 'msdb.dbo.logmarkhistory'.

The object msdb.dbo.logmarkhistory does not exist on the SQL server receiving the error but it does exist on other SQL servers protected by SQL Backup.

Any suggestions?

Dan B

Hi Navillus,

The 'msdb.dbo.logmarkhistory' should be part of the MSDB database. If you don't have a valid backup of the MSDB table the best option here would probably be to rebuild the documentation as per https://docs.microsoft.com/en-us/sql/relational-databases/databases/rebuild-system-databases

Dan B

Hi navillus,

Is the SQL Server version different on this machine receiving the warning vs the other machines?

navillus

No, all of the protected SQL Servers are 2012 build 11.0.5388.

Thanks,
Michael

navillus

OK, thank you for the information.