July 8, 2002 at 10:56 am
I have been having troubles with removing .BAK file of my database. I have DB Maintenance job to back up my databases and have them removed after 1 day. But they are not being removed and I keep running out of disk space and the job fails. Nothing is accessing these files at the time of removal, they're not marked read only and SQL has full access to the directory. Any I Ideas.
July 8, 2002 at 12:54 pm
The delete only happens after the backup is complete. I've got an article I recently posted that goes into more detail. If you need the files deleted first, you'll have to add either a step before the backup step, or a separate job.
Andy
July 8, 2002 at 1:29 pm
You can also write some script to remove them manually.
Steve Jones
July 11, 2002 at 2:46 am
Hi,
U can use XP_CMDSHELL and del those files (define a schedule job)before next backup job run , but be careful about using this extended stored procedure.
SaNaZ
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply