Home > Archive > MS SQL Server > October 2006 > Maintenance Plan Configuration









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Maintenance Plan Configuration
John

2006-10-24, 6:38 pm

Hi,

I've just started using SQL Server 2005 Standard and I'm moving database
across from SQL Server 2000.

I have setup a maintenance plan to backup my databases in the new
maintenance plan tool / SSIS but I cannot find any option to delete old
database backup files like I have in SQL Server 2000.

I found the Clean-up History task, but this does not appear to be related to
deleting database backup files.

Can someone please point me in the right direction for configuring this
option so I do not need to write my own job to delete old backup files.
MarkusB

2006-10-24, 6:38 pm


John

add a "Maintenance Clean Up" task to your Maintenance plan. This will
give you the option to delete old backfiles or logfiles.

Markus

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com