Timeline for How do I get more control over backup file retention using Ola Hallengren's DatabaseBackup solution?
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 19, 2019 at 3:26 | vote | accept | Jeff Edmunds | ||
| Jun 19, 2019 at 3:24 | comment | added | Jeff Edmunds | Randi - these are mostly smallish databases. I think the entire job generally completes in about a minute. | |
| Jun 18, 2019 at 22:35 | answer | added | HandyD | timeline score: 2 | |
| Jun 18, 2019 at 21:16 | history | edited | Randi Vertongen | CC BY-SA 4.0 |
added 32 characters in body; edited tags
|
| Jun 18, 2019 at 21:15 | comment | added | Randi Vertongen | How long do your backups take? | |
| Jun 18, 2019 at 21:15 | comment | added | S3S | It won't keep two copies, just as many copies that aren't 48 hours old. It's not about when your job starts, but when your job finishes. I still wouldn't expect this to leave three copies generally, unless one of them took a ridiculous amount of time to complete placing it within the 48 hour window. I suspect this is what is happening. | |
| Jun 18, 2019 at 21:00 | comment | added | Jeff Edmunds | Hi Scott. Yep, these are full only backups and in most cases the databases are using the Simple recovery model. (Not sure if that info helps but figured it couldn't hurt...) | |
| Jun 18, 2019 at 20:59 | history | edited | Jeff Edmunds | CC BY-SA 4.0 |
added 278 characters in body
|
| Jun 18, 2019 at 20:38 | comment | added | Scott Hodgin - Retired |
Can you update your question to show the actual backup command parameters? Are you taking full only backups?
|
|
| Jun 18, 2019 at 20:35 | review | First posts | |||
| Jun 19, 2019 at 5:40 | |||||
| Jun 18, 2019 at 20:32 | history | asked | Jeff Edmunds | CC BY-SA 4.0 |