| Tom Moreau 2002-08-07, 8:23 am |
| You can use a Database Maintenance Plan for this. When you run the wizard, you will eventually get a dialog box that asks you where to save the backups. There is a check box that allows you to retain backups for a period of time. If you do one backup/day, then have it remove files older than 4 days.
HTH
--
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
www.apress.com
"Larry C" <ljcoppinger@attbi.com> wrote in message news:148f01c23e0f$55b8c840$37e
f2ecf@TKMSFTNGXA13...
I am trying to get sql 2000 to back up to disk and keep
the last 3 backups only. ie. write new back up and purge
4th oldest keeping backup file consistently with 4 back
ups only.
|