Warning 164: Failed to delete backup entries in msdb tables

paulnxwebpaulnxweb Posts: 21
edited November 2, 2006 11:24AM in SQL Backup Previous Versions
I'm running RedGate using the command line under a Windows 2003 Administrator account. I get this warning message.

Warning 164: Failed to delete backup entries in msdb tables: Timeout expired



************Full error message**********

BACKUP DATABASE successfully processed 942684 pages in 487.850 seconds (15.829 MB/sec).
11/2/2006 12:18:22 AM: SQL Backup process ended.

11/2/2006 12:18:22 AM: Deleting log file: C:\RedGateData\Log\RedGateLog\20061026 010505 01 {49235137-B207-4A61-AE79-CC9A1505D28D}.log
11/2/2006 12:18:22 AM: Deleting log file: C:\RedGateData\Log\RedGateLog\20061026 011004 01 {DB5C65E7-27FC-4933-808B-E17F9893EA05}.log
11/2/2006 12:18:22 AM: Deleting log file: C:\RedGateData\Log\RedGateLog\20061026 011503 01 {12EADE57-EB81-4769-A86A-C4784315C11E}.log
11/2/2006 12:18:48 AM: Warning 164: Failed to delete backup entries in msdb tables: Timeout expired
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    That is a warning to indicate that the stored procedure to delete old backup history (sp_delete_backuphistory) failed to run to completion. The backup itself succeeded.

    This could happen if you have a very large msdb table, or your server was busy at that time, thus preventing sp_delete_backuphistory to complete.

    Is this the first time you are using the log deletion functions? If so, you might consider running sp_delete_backuphistory manually once to 'trim' the backup/restore history tables.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.