Backup set to expire, but doesn't
-
The "backup set will expire:" I have this checked off, but the backups are not being purged..any suggestions?
Thanks..Nali
-
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 -
Expire means that the space can be resused, not that the file/data is removed. As Jeffrey mentioned, you need to cleanup yourself.
-
So how do you suggestion cleaning up after yourself? CMD or VB script?
I'm running into the same issue.
-
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.
---------------------------------------------------------------------
-
But this won't clean up the backup files will it? Only the Index...
Forgive me I'm not a DB Admin
-
no you can use it to delete .bak files, just speccify the directory holding the backup and the backup file extension (usually bak)
---------------------------------------------------------------------
-
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