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.John
add a "Maintenance Clean Up" task to your Maintenance plan. This will
give you the option to delete old backfiles or logfiles.
Markus
Showing posts with label databaseacross. Show all posts
Showing posts with label databaseacross. Show all posts
Wednesday, March 28, 2012
Maintenance Plan Configuration
Labels:
configuration,
database,
databaseacross,
maintenance,
microsoft,
moving,
mysql,
oracle,
plan,
server,
setup,
sql,
standard
Maintenance Plan Configuration
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.
John
add a "Maintenance Clean Up" task to your Maintenance plan. This will
give you the option to delete old backfiles or logfiles.
Markus
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.
John
add a "Maintenance Clean Up" task to your Maintenance plan. This will
give you the option to delete old backfiles or logfiles.
Markus
Labels:
configuration,
database,
databaseacross,
ive,
maintenance,
microsoft,
moving,
mysql,
oracle,
plan,
server,
setup,
sql,
standard
Subscribe to:
Posts (Atom)