locked
SQL 2005 Backup maintenance plan RRS feed

  • Question

  • In SQL 2005...

    How do I specifty in the maintenance plan to only keep 3 days worth of backup.

    Andre

    Friday, February 16, 2007 6:42 PM

Answers

  • Use 'Maintenance Cleanup Task' under Maintenance plan tasks and configure 'File Age'.
    Tuesday, February 20, 2007 7:26 PM

All replies

  • Use 'Maintenance Cleanup Task' under Maintenance plan tasks and configure 'File Age'.
    Tuesday, February 20, 2007 7:26 PM
  • Thank you!  I've been looking for that answer in books and online and was about to ask the question myself when I found yours. 

    Linda
    Friday, February 23, 2007 3:24 PM
  • Make sure to check the updates under SQL Server books online (February 2007) update about maintenance plans.
    Monday, February 26, 2007 2:56 PM