What are the challenges you face when working across database platforms? Take the survey
Options

Warning 164: Failed to delete backup entries in msdb tables

banditobandito Posts: 3
edited September 16, 2008 4:52AM in SQL Backup Previous Versions
Hi
all my jobs on TRN are in failure and all for the same reason.
Warning 164: Failed to delete backup entries in msdb tables: Error of conversion of the type of data varchar in datetime. it is the first time that I have this problem since the installation.
I have sqlbackup 4.6 pro

the log of a job:
SQL Backup log file
12/09/2008 10:03:01: Backing up Bo (transaction log) to:
D:\Backup\TRN\Bo\Bo_20080912_100301.sqb

12/09/2008 10:03:01: BACKUP LOG [Bo] TO DISK = 'D:\Backup\TRN\Bo\Bo_20080912_100301.sqb' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', ERASEFILES = 1, MAILTO_ONERROR = 'systeme.reseau@domaine.com', COMPRESSION = 3, THREADS = 1

12/09/2008 10:03:06: Backup data size : 120,688 MB
12/09/2008 10:03:06: Compressed data size: 28,604 MB
12/09/2008 10:03:06: Compression rate : 76,30%

15217 pages traitées pour la base de données 'Bo', fichier 'Bo_Journal' sur le fichier 1.
BACKUP LOG a traité avec succès 15217 pages en 5.100 secondes (24.441 Mo/s).

12/09/2008 10:03:24: Deleting old backup file: D:\Backup\TRN\Bo\Bo_20080911_100301.sqb
12/09/2008 10:03:24: SQL Backup process ended.

12/09/2008 10:03:25: Warning 164: Failed to delete backup entries in msdb tables: Erreur de conversion du type de données varchar en datetime.
.
12/09/2008 10:03:25: Mail sent successfully to: systeme.reseau@domaine.com

Thanks

Comments

Sign In or Register to comment.