tag:blogger.com,1999:blog-495177919198719500.post5196726310319717521..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: Shrink a Live SQL Server Database and Logs - Caveats and Best PracticesSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-495177919198719500.post-6806802423571692862016-04-23T22:38:21.410-07:002016-04-23T22:38:21.410-07:00Thanks for the comments. My point on on setting re...Thanks for the comments. My point on on setting recovery mode to simple is under the assumption that the recovery mode is already FULL. In that case it is better to set it SIMPLE and then to FULL when doing the shrinkingUnknownhttps://www.blogger.com/profile/13241916831072779717noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-62343441579019317202016-03-26T20:07:43.655-07:002016-03-26T20:07:43.655-07:00Good stuff, although I have my doubts about settin...Good stuff, although I have my doubts about setting recovery mode to SIMPLE first and then FULL after the shrink.Anonymoushttps://www.blogger.com/profile/06847387888246690316noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-21205423031325886762016-03-24T13:33:10.677-07:002016-03-24T13:33:10.677-07:00Hmm, you shouldn't need to "set the Recov...Hmm, you shouldn't need to "set the Recovery mode into SIMPLE ... and make it FULL after shrinking."<br /><br />If you're in FULL recovery mode already, run your transaction log backup job. That'll make that log shrink right down.<br /><br />If you're already using SIMPLE, there's no need to ever set it to FULL.cmsheflerhttps://www.blogger.com/profile/15951967509086033323noreply@blogger.com