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 |
|
Blin
Starting Member
36 Posts |
 Posted - 2004-11-03 : 13:05:37
|
| I was under an impression that if I set retention period in sp_configure to a specific day, then my backupsets would be retained for that period and would be overwritten when the period expires; thus, my xxxx.bak, which contains multiple backupsets, would not grow that much and disk space could be saved because existing backupsets would be overwritten. However, I found that xxxx.bak is still continuing to grow and backupsets are still being generated with new backupset id's and position numbers when retention period expired.I'd like to know how I can remove older backsets from xxxx.bak file. I use EM to do the backups and 'append to media' option is chosen. The free disk space is reducing everyday and eventually will be running out. Any suggestions in this regard will be appreciated. |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-03 : 13:45:34
|
| I reckon the advice you are going to get here is to uniquely name your backup files, and purge the ones that are older than X days.Scripts to do that can be found at:http://weblogs.sqlteam.com/tarad/category/95.aspxKristen |
 |
|
|
|
|
|
Retention period for backupsets