Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    68

    Unanswered: delete backup file

    Hi,
    I have a database which size is 64Go, and i backup it everyday with 1 day of retention.
    But the maintenance plan don't delete the file older than 1 day.
    This works fine for the other db.
    Do you know what is the pb ?
    regards.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by philio
    Hi,
    I have a database which size is 64Go, and i backup it everyday with 1 day of retention.
    But the maintenance plan don't delete the file older than 1 day.
    This works fine for the other db.
    Do you know what is the pb ?
    regards.

    Does the maintenance plan generate an error log? It should be in %Install Path%\MSSQL\LOGS. Look through there. As I recall, if there is any problem anywhere in the process of making the backup, the purge old files process will not work (this is by design).

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •