Timeline for Transaction log backups cleaning
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 1, 2016 at 6:49 | comment | added | ddaniel | 15 or 30 minutes of data-loss is acceptable, this is why I'm backing up the logs every 15 minutes. I'm thinking about keeping the logs for a week, and in the weekend automate a restore simulation. If that succeeds, I'll delete the logs. Thanks! | |
| Feb 29, 2016 at 22:46 | comment | added | user541852587 | Let me ask it this way: what's the maximum amount of data that you're okay with losing? If the answer is 0, always play it safe. | |
| Feb 29, 2016 at 22:43 | vote | accept | ddaniel | ||
| Feb 29, 2016 at 22:27 | comment | added | ddaniel | I understand your point. I will see how can we fit a restore scenario into our DR plan, but basically, you're saying that I should keep my log backups until I'm 100% sure that I already have a valid backup that "contains" them, right? | |
| Feb 29, 2016 at 22:21 | history | answered | user541852587 | CC BY-SA 3.0 |