View Complete Post
I have configured my SQL Server 2005 to take backups and I have another program running to compress these files to .RAR extension to save space.
I have a Maintenance Cleanup Task also configured to delete old .RAR files but it does not work. I have specified the extension to look for to be RAR and the job runs without error but no files are deleted.
Is it that only BAK and TRN files are deleted using Maintenance Cleanup Task?
I have a DBA who put a typo in a log backup filename. I cannot see the backup and cannot delete it, but it is taking up space.
How do I delete it?
I assume I will have to do it from SQL as the O/S cannot see it. XP_FILE_DELETE cannot see the file.
Thanks for any assistance
If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.
MSDN Magazine May 2009