DB Backups are not getting deleted automatically in SQL SERVER 2005

  • The maintenance cleanup task expects the extension without the period. If you put the period in, it will not remove any files.

    Also, make sure you have selected the right kind of files to be removed. If you have selected maintenance plan report files, it will not remove backup files.

    And finally, if the backups are not native SQL Server backup files - it will not work either. So, if you are using Litespeed, Redgate SQL Backup, or some other third party backup software - those files can only be removed using the third parties cleanup task.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply