December 24, 2009 at 9:11 pm
The "backup set will expire:" I have this checked off, but the backups are not being purged..any suggestions?
Thanks..Nali
December 25, 2009 at 9:23 am
Using that does not do what you are expecting it to do - it is a holdover from when the devices were tape.
Stop using a device - use a folder, separate files and the maintenance plan cleanup task. Or you can roll your own cleanup utility to cleanup a directory of files.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 25, 2009 at 10:47 am
Expire means that the space can be resused, not that the file/data is removed. As Jeffrey mentioned, you need to cleanup yourself.
January 8, 2010 at 3:04 pm
So how do you suggestion cleaning up after yourself? CMD or VB script?
I'm running into the same issue.
January 8, 2010 at 3:24 pm
dsuurvarik (1/8/2010)
So how do you suggestion cleaning up after yourself? CMD or VB script?I'm running into the same issue.
easiest way is to use the backup task to backup to file in a maintenance plan and follow that with a cleanup task.
---------------------------------------------------------------------
January 8, 2010 at 3:31 pm
But this won't clean up the backup files will it? Only the Index...
Forgive me I'm not a DB Admin
January 8, 2010 at 4:05 pm
no you can use it to delete .bak files, just speccify the directory holding the backup and the backup file extension (usually bak)
---------------------------------------------------------------------
January 8, 2010 at 11:08 pm
I'll check it out. Thanks you 🙂
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply