Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aririikonen
Starting Member
3 Posts |
 Posted - 2004-04-15 : 07:09:59
|
| Hiya,Environment:MS SQL Server 2000 Standard EditionWindows 2000 ServerWe have a disk backup file device where we are storing the transaction log backups once per hour. I've set an expiration date to the backups, but it seems that the expired backups are not being removed from the file automatically.Any way you can remove backup sets from the disk backup file device? Commands to do this?The problem is that the backup file device size is growing (at 2,3GB now) and some transaction log backups are not relevant anymore.Br,Ari |
|
|
kish
Starting Member
45 Posts |
Posted - 2004-04-15 : 08:19:31
|
| Hi,Have u scheduled to take log backups every hour. If yes, then you have the option to remove log backups after particular hour.This is present in the Database Maintainence Planner Wizard for Backing up databases. Hope this helps. |
 |
|
|
aririikonen
Starting Member
3 Posts |
Posted - 2004-04-15 : 10:03:13
|
| >Have u scheduled to take log backups every hour. If yes, then you >have the option to remove log backups after particular hour.>>This is present in the Database Maintainence Planner Wizard for >Backing up databases. Hope this helps.Hey,I've scheduled it, but I didn't create it through the Database Maintenance Planner Wizard. I did the transaction log backup from the backup device. (... -> Management -> Backup -> Right click -> "Backup a Database..."). This created the Job to SQL Server Agent -> Jobs.The basic issue is that if I have a disk backup file. How can I remove backup "sets" inside that device file?I can list the backup "sets" with (... -> Management -> Backup -> Right click a backup device -> Properties -> "View contents...").Br,Ari |
|
|
|
surefooted
Posting Yak Master
188 Posts |
Posted - 2004-04-15 : 12:05:35
|
| Open the job and go to the SQL statement and add ", RETAINDAYS = #" with the # begin replaced by the number of days you want to keep the backup. |
|
|
|
aririikonen
Starting Member
3 Posts |
Posted - 2004-04-22 : 09:34:36
|
| I have the RETAINDAYS=7 option set, but its not removing the old file from the backup datafile.Br,Ari |
|
|
|
|
|
|
|
|
Disk backup file device - clean up