Timeline for SQL Server 2008, switching to simple recovery mode
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 9, 2012 at 11:47 | history | tweeted | twitter.com/#!/StackDBAs/status/167575256268148737 | ||
| Feb 9, 2012 at 11:19 | history | migrated | from serverfault.com (revisions) | ||
| Feb 9, 2012 at 10:49 | comment | added | Rob Moir | @NimChimpsky - moved my comments to an answer and tidied them up a bit | |
| Feb 9, 2012 at 10:44 | vote | accept | CommunityBot | ||
| Feb 9, 2012 at 10:36 | comment | added | Chopper3 | @NimChimpsky - love the username, wonder how many will fully 'get it' :) | |
| Feb 9, 2012 at 10:35 | answer | added | Rob Moir | timeline score: 4 | |
| Feb 9, 2012 at 10:24 | comment | added | NimChimpsky | @RobMoir after switching to simple recovery mode, which can apparently be done on a live server with no effects. Do I need to do anything to shrink the log file, or will it just start reducing down automatically over time ? | |
| Feb 9, 2012 at 10:12 | comment | added | NimChimpsky | @RobMoir I said in my question I want to switch to simple recovery mode. I wanted to know the correct procedure for shrinking reducing the transaction log size. | |
| Feb 9, 2012 at 10:03 | answer | added | Mathias R. Jessen | timeline score: 3 | |
| Feb 9, 2012 at 9:55 | history | asked | NimChimpsky | CC BY-SA 3.0 |