在整理手上几台SQL SERVER 2000的数据库备份时，一方面为了方便快速还原数据库，另外一方面为了备份冗余、备份方式统一（先备份到本地，然后收上磁带），将以前通过Symantec Backup Exec直接备份上带的作业改成了如下方式：
Step 1： 通过数据库维护计划将备份生成在本地磁盘M，完整备份保留2天，事务日志备份保留3天
M:\DB_BACKUP\FULL_BACKUP
M:\DB_BACKUP\LOG_BACKUP
Step 2: 备份完成后通过Symantec Backup Exec将备份文件收上磁带。
但是发现即使SQL SERVER 2000的数据库维护计划设置了删除几天前的备份文件，但是发现根本没有删除过期备份。于是只好使用dos命令来处理。刚开始想用forfiles命令，结果我搜索的时候，发现Windows 2000下没有forfiles命令，后来通过从第三方复制过来，发现Windows 2000下也可以使用forfiles（如果不借助于forfiles命令，直接用批处理命令完成这个，那简直痛苦死了）
关于forfiles命令的语法如下所示
C:\>forfiles /?
FORFILES [/P pathname] [/M searchmask] [/S]
[/C command] [/D [+ | -] {yyyy-MM-dd | dd}]
Description:
Selects a file (or set of files) and executes a
command on that file. This is helpful for batch jobs.
Parameter List:
/P pathname Indicates the path to start searching.
The default folder is the current working
directory (.).
/M searchmask Searches files according to a searchmask.
The default searchmask is '*' .
/S Instructs forfiles to recurse into
subdirectories. Like "DIR /S".
/C command Indicates the command to execute for each file.
Command strings should be wrapped in double
quotes.
The default command is "cmd /c echo @file".
The following variables can be used in the
command string:
@file - returns the name of the file.
@fname - returns the file name without
extension.
@ext - returns only the extension of the
file.
@path - returns the full path of the file.
@relpath - returns the relative path of the
file.
@isdir - returns "TRUE" if a file type is
a directory, and "FALSE" for files.
@fsize - returns the size of the file in
bytes.
@fdate - returns the last modified date of the
file.
@ftime - returns the last modified time of the
file.
To include special characters in the command
line, use the hexadecimal code for the character
in 0xHH format (ex. 0x09 for tab). Internal
CMD.exe commands should be preceded with
"cmd /c".
/D date Selects files with a last modified date greater