Timeline for Large transactional log won't shrink after transactional backup
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 10, 2017 at 13:35 | comment | added | Sami.C | The answer is a little bit hit and miss. I attempted to defrag my indexes which further ballooned the log file out. I tried to run another transaction backup and on this occasion it was able to release it and 99% of the log was unused. I was then able to shrink the database successfully :) | |
| Jul 10, 2017 at 12:21 | vote | accept | Sami.C | ||
| Jul 10, 2017 at 10:36 | comment | added | Ramakant Dadhichi | Let us continue this discussion in chat. | |
| Jul 10, 2017 at 10:09 | history | edited | Ramakant Dadhichi | CC BY-SA 3.0 |
Asked a question
|
| Jul 10, 2017 at 10:04 | history | answered | Ramakant Dadhichi | CC BY-SA 3.0 |