How can we help you today? How can we help you today?

Warning 164?

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?
navillus
0

Comments

4 comments

Sort by
  • Dan B
    Hi navillus,

    Is the SQL Server version different on this machine receiving the warning vs the other machines?
    Dan B
    0
  • navillus
    No, all of the protected SQL Servers are 2012 build 11.0.5388.

    Thanks,
    Michael
    navillus
    0
  • 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
    0
  • navillus
    OK, thank you for the information.
    navillus
    0

Add comment

Please sign in to leave a comment.