Warning 164: Failed to delete backup entries in msdb tables

paulnxweb

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

petey

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.