Overwirte backup data

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi,

I have a backup plan that backs data up to a backup devie (disk). The physical backup file becomes big overtime. I want to keep my backup data in the hard drive for 7 days and remove or overwrite those older than that. Using SQL Server's "Database Maintenance Planner" to "remove files older than" seems not working for my current backup plan. Please advice and I greatly appreciate your help!

Note: SQL Server 2000 on Win2000 Advanced Server Cluster.

Yichang

-- Anonymous, June 27, 2001

Answers

Yichang,

There are some reports that if some of the previous backups are manual and others are automatic (via the Database Maintenance Planner) that the planner may not work properly.

Hope this helps,

Eric

-- Anonymous, June 28, 2001


Moderation questions? read the FAQ