Silent compression for faster, smaller SQL Server backups
Moderators: eddie davis, Colin Millerchip, fionag
We have a maintenance plan (including Maintenance Cleanup Task) that backs up a collection of databases and then deletes files older than 5 days. The plan used to work fine when our backups had a .bak extension.
We recently installed HyperBac 5 and started taking encrypted backups with the .hbe extension. These backups are working fine but even though I have changed the file extension in the Maintenance Cleanup Task, old backups are no longer being deleted.
Can anyone help?
SQL Server 2005 Enterprise
- Posts: 2
- Joined: Tue Jan 25, 2011 3:10 pm
Thank you for your post into the forum. I believe that you also submitted a support request via the Red Gate Web Site and a support call has been created, call reference number F0043729.
Sorry that you have encountered a problem.
Are there any errors in the SQL Server Error Logs or activity history for the clean up job that indicate the failure and a reason as to why the failure occurred?
My first suspicions is that the job owner does not have permissions to decrypt the backups so that the file header can be read to see if the backup file meets the criteria for deletion.
Can you please reply with a copy of the HyperBac service.log file and copies of any other log files that exist in the HyperBac logs folder?
From the Maintenance Cleanup Task, can you please identify the code that performs the backup file deletion and send to us the syntax used?
- Posts: 942
- Joined: Wed Jun 14, 2006 3:47 pm
- Location: Red Gate Software
Return to SQL HyperBac 5
Who is online
Users browsing this forum: No registered users and 0 guests