Maitenance plan -- sql server new users

DD
3/19/2007 12:00:00 AM

Hello,

I use Microsoft SQL 2005 enterprise edition.
I perform backup of my databases with maintenance plans. I would like this
maintenance plan to delete backup older than 2 days. Is it possible? With
SQL 2000, it was quite easy.

Thanks in advance,
David

Sue Hoegemeier
3/19/2007 8:16:36 PM

Modify the maintenance plan and add a Maintenance Cleanup
Task. This task allows you to define the conditions you want
to use to delete older backups.

-Sue

On Mon, 19 Mar 2007 12:04:50 +0100, "DD" <noreply@msn.com>
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

sql server new users : Maitenance plan