Timeline for Log sizes unexpectedly large: log_reuse_wait_desc == "log_backup"
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 23, 2013 at 9:54 | comment | added | Twinkles | Please do not change the recovery model to SIMPLE just to shrink the logfile. | |
| Oct 23, 2013 at 16:05 | comment | added | Jamie Holloway | the system is dead quiet... | |
| Oct 23, 2013 at 8:20 | comment | added | Punter015 | Could you check for sessions/connections to the database. Use sp_who2 Also you can use adam machanic's script sqlblog.com/blogs/adam_machanic/archive/2012/03/22/… | |
| Oct 22, 2013 at 22:03 | comment | added | Jamie Holloway | #1 -- no unusual activity, system is quiet, dbdc opentrans indicates no transactions, #2 and #4 -- yes, i just removed a rebuild index from a proc to see if this helps, #3 -- 2268 VLFs status == 2, #5 -- ok, makes sense, but if log-truncation occurs, i should expect VLF records w/o status=2, and 'available space in mb' from sys.database_files to show available space, correct? also, log_reuse_wait_desc should return to "nothing" | |
| Oct 22, 2013 at 12:39 | review | First posts | |||
| Oct 22, 2013 at 17:56 | |||||
| Oct 22, 2013 at 12:20 | history | answered | Punter015 | CC BY-SA 3.0 |