January 2, 2003 at 5:02 am
Hi,
I am backing up sql7 databases through sqlmaint, but old backups are not being deleted. Can anyone help?
sqlmaint -S zxxxxx -D yyy -BkUpDB E:\mssql7\backup\yyy -BkUpMedia DISK -DelBkUps 1days
Huw
January 2, 2003 at 8:48 am
Is the job finishing without an error? Check the maint plan history (not the job). Deletes get done after the backup, if the backup fails - say out of space - the files dont get deleted.
Andy
January 2, 2003 at 8:53 am
quote:
Is the job finishing without an error? Check the maint plan history (not the job). Deletes get done after the backup, if the backup fails - say out of space - the files dont get deleted.Andy
http://www.sqlservercentral.com/columnists/awarren/
There are no error messages - I get the reply that there are 0 backups to be deleted when there are at least 5 days worth on a 1 day delete
Thanks
Huw.
January 2, 2003 at 9:22 am
And the files match to a backup you're doing?
Andy
January 6, 2003 at 3:58 am
Yes - the files follow normal naming pattern dbname_db_datestamp - Ive checked the system table (backupmediafamily) and this matches as well.
I think I have spotted the problem, the backups are not going to the default backup directory, they are going to sub-directories.
Huw.
Edited by - huw on 01/06/2003 04:45:25 AM
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply