any Microsoft SQL DBAs around the house? (SQL 2000)

[tami]

i'm having an issue when using SQL enterprise manager to delete old *.BAK files after the most recent backup. i have chosen that any backups older than 1 hour old should be deleted, but they don't seem to be, and the *.BAK files accumulate, leaving little space on the harddrive

this is microsoft's wonderful support answer to this question:

Host: Pankaj (Microsoft)
Q: Using the maintenance wizard, I select the option to delete old .trn and .bak files after 1 day, but these files don't get deleted.

A: There could be lots of reasons for this. Most common reason is that the files are being locked out by another process like backup software.

from http://www.microsoft.com/technet/community/chats/trans/sql/sql0408.mspx

unfortunately, this pankaj dude is wrong, since the files are not locked and i can safely delete them myself. the program, however, does not delete the files, causing problems.

does anyone recognize the problem and know of a fix for this?

thanks.

 

[KLin]

good newsgroup article on some things to check.

 

[tami]

thanks KLin, gonna check those out.