Timeline for Managing Transaction Log Size using a Maintenance Plan [duplicate]
Current License: CC BY-SA 3.0
20 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 24, 2014 at 17:03 | history | closed |
Paul White♦ RolandoMySQLDBA Mark Storey-Smith Hannah Vernon♦ Kin Shah |
Duplicate of Why Does the Transaction Log Keep Growing or Run Out of Space? | |
| Feb 22, 2014 at 11:50 | answer | added | dsingh | timeline score: 0 | |
| Feb 22, 2014 at 4:51 | review | Close votes | |||
| Feb 24, 2014 at 17:03 | |||||
| Feb 22, 2014 at 4:35 | history | edited | Paul White♦ | CC BY-SA 3.0 |
edited tags; edited title
|
| Feb 21, 2014 at 20:48 | answer | added | Ivan Stankovic | timeline score: 0 | |
| Feb 9, 2012 at 14:42 | answer | added | RK Kuppala | timeline score: 0 | |
| Feb 9, 2012 at 10:20 | vote | accept | Neil Knight | ||
| Feb 9, 2012 at 8:47 | history | tweeted | twitter.com/#!/StackDBAs/status/167529957105467393 | ||
| Feb 8, 2012 at 18:13 | answer | added | Aaron Bertrand | timeline score: 5 | |
| Feb 8, 2012 at 16:44 | vote | accept | Neil Knight | ||
| Feb 8, 2012 at 22:01 | |||||
| Feb 8, 2012 at 16:43 | comment | added | JNK | Log gets reused, but depending on your backup strategy you can probably shrink the LOG | |
| Feb 8, 2012 at 16:41 | comment | added | Neil Knight | As the log is so large, will it shrink automatically? | |
| Feb 8, 2012 at 16:40 | comment | added | JNK | it will cause all kinds of IO activity, increase fragmentation, etc etc etc. shrinking of DB files should be done very carefully and manually and with great caution. | |
| Feb 8, 2012 at 16:40 | answer | added | db2 | timeline score: 4 | |
| Feb 8, 2012 at 16:38 | comment | added | Neil Knight | @JNK: Care to eloborate? | |
| Feb 8, 2012 at 16:36 | comment | added | JNK | Never ever ever ever ever ever ever ever ever ever automate or schedule a database shrink. Ever. For any reason. Ever. Really, not ever. EVER. | |
| Feb 8, 2012 at 16:33 | history | migrated | from stackoverflow.com (revisions) | ||
| Feb 8, 2012 at 16:25 | comment | added | Neil Knight | The transaction log file is now up to around 35Gb. | |
| Feb 8, 2012 at 16:22 | comment | added | antlersoft | The answer to this question depends entirely on the specifics of the applications your DB supports. | |
| Feb 8, 2012 at 16:19 | history | asked | Neil Knight | CC BY-SA 3.0 |