As job step within a maintenance plan, backup files greater than a certain age should be deleted; however, when executed, the backup files do not get deleted for any databases with the text '_db' in the database name. All other database backup files delete without any problems.
Design of LiteSpeed procedure PRC_DBMAINT_SLSBACKUP
This problem is caused by the LiteSpeed procedure 'PRC_DBMAINT_SLSBACKUP', located within the MSDB database. As part of this procedure, any backup created using a LiteSpeed Maintenance Plan creates a backup file name DATABASENAME_db_DATE.BAK. So when a database name already has the text '_db' in its name, such as SQL_db, a backup file created via a maintenance plan for this database would create a file called SQL_db_db_20060302.BAK. The problem is that when you perform another backup of the same database and have set it to delete old backup files, the name being picked up is simply SQL_db_20060302.BAK, as it is not picking up the extra '_db' text in the backup file name.
WORKAROUND
Please contact Support@Quest.com to obtain a script that contains a new procedure 'PRC_DBMAINT_SLSBACKUP', which replaces the existing one on MSDB. This will ensure that for any new backups you perform, the old file is picked up by including the extra _DB text in the filename.
STATUS
Issue fixed in latest version.
Please contact support to download the latest version of NetVault LiteSpeed for SQL Server.
