Windows Forum

Ask something
Discussion Locked

SQL Server 2000 Database Maintenance

0 helpful
4 replies

by ericd173

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have the database maintenance set to delete backups older than 7 days but it does not. These backups continue to grow until all disk space is used. I have read elsewhere that perhaps backup software is locking the files. My Veritas backup runs at 2AM and the SQL backup at 10PM, so I don't think this is an issue, but I could be wrong. I am relative newb to SQL so any info you may be able to supply in regards to this problem would be greatly appreciated. If more info is needed from me, just ask.

4 replies

by dbowlin

Does the user name the SQL back up is running under have permission to delete files in the back up directories?

I have also seen this problem, and seen the recomendation of doing maintenance by script rather than by the maintenance wizard & properties boxes in the Enterprise Manager.

Good luck.

by ericd173

The problem has been in existance since prior to me taking over this network and the backups used to be on the SQL Server and are run under Administrator, so I don't think this is it. The backup directory was moved to a NAS as a bandaid to the problem, but I would really like to actually fix it.

This discussion is closed to new replies.