| GregS 2006-03-14, 11:23 am |
| I am running the following command via a scheduler against our SQL Server
2000 server:
sqlmaint -S "<server>" -D "midprd" -BkUpDB G:\MSSQL\BACKUP\midp
rd -BkUpMedia
DISK -DelBkUps 4days
And I get the output of:
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.760
Copyright (C) Microsoft Corporation, 1995 - 1998
Logged on to SQL Server '<server>'
as 'MAUCORP\MAUBATCH' (trusted)
Starting maintenance of database 'midprd' on 3/13/2006 7:00:01 PM
[1] Database midprd: Database Backup...
Destination: & #91;G:\MSSQL\BACKUP\
midprd\midprd_db_200
603131900.BAK]
** Execution Time: 0 hrs, 6 mins, 18 secs **
[2] Database midprd: Delete Old Backup Files...
0 file(s) deleted.
End of maintenance for database 'midprd' on 3/13/2006 7:06:19 PM
SQLMAINT.EXE Process Exit Code: 0 (Success)
However, the backup directory does have files older than the specified four
days. I changed the backup destination directory to be maintainable by
'Everyone' to remove security from the list of possibilities.
I can execute the above command on the server (without the "-S") and it does
delete old files. Is there a restriction with the use of DelBkUps on a remote
call?
Thank you,
Greg
|