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 |
|
lordzoster
Starting Member
29 Posts |
 Posted - 2005-03-22 : 10:34:41
|
| Hallois it possible to delete sets of backup older than a certain amount of days?e.g., i'd like to write full backup of a database to a backup device, with 'no init' option, but to drop the backup sets when the become older than 15 days.Do you think it is possible? How should i go? |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-22 : 10:37:24
|
| Don't store your backups like this. Store them as individual files. If you get corruption anywhere in the file, you lose your entire backup set. You can set the retaindays option for backup I believe if you want to go down this route though.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
lordzoster
Starting Member
29 Posts |
Posted - 2005-03-22 : 10:41:52
|
| ok thx - i suspected that it wasn't the best practice to manage backups, but i use 3 different backup devices in 3 different locations.Anyway, "retaindays" isn't the solution.Thanks, i'll use this (http://www.mindsdoor.net/SQLAdmin/BackupAllDatabases.html) method |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-03-22 : 10:47:03
|
| That's the preferred method. You also might want to look at Tara Duggan's scripts here:http://weblogs.sqlteam.com/taradMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
delete single backup set?