How a log file structure can affect database recovery timehttp://blogs.msdn.com/psssql/archive/2009/05/21/how-a-log-file-structure-can-affect-database-recovery-time.aspxWe frequently come across situations where databases take a long time to recover. A common scenario is where the recovery process has to roll forward or back several transactions for a database after a SQL Server restart. However, you might also see oneenCommunityServer 2.1 SP1 (Build: 61025.2)How a log file structure can affect database recovery time | Microsoft Share Pointhttp://blogs.msdn.com/psssql/archive/2009/05/21/how-a-log-file-structure-can-affect-database-recovery-time.aspx#9634194Thu, 21 May 2009 22:22:30 GMT91d46819-8472-40ad-a661-2c78acb4018c:9634194How a log file structure can affect database recovery time | Microsoft Share Point<p>PingBack from <a rel="nofollow" target="_new" href="http://microsoft-sharepoint.simplynetdev.com/how-a-log-file-structure-can-affect-database-recovery-time/">http://microsoft-sharepoint.simplynetdev.com/how-a-log-file-structure-can-affect-database-recovery-time/</a></p> re: How a log file structure can affect database recovery timehttp://blogs.msdn.com/psssql/archive/2009/05/21/how-a-log-file-structure-can-affect-database-recovery-time.aspx#9640443Mon, 25 May 2009 16:00:07 GMT91d46819-8472-40ad-a661-2c78acb4018c:9640443grahamk<p>I have a demo of how this can affect database mirroring with sample code here <a rel="nofollow" target="_new" href="http://blogs.msdn.com/grahamk/archive/2008/05/09/1413-error-when-starting-database-mirroring-how-many-virtual-log-files-is-too-many.aspx">http://blogs.msdn.com/grahamk/archive/2008/05/09/1413-error-when-starting-database-mirroring-how-many-virtual-log-files-is-too-many.aspx</a></p> re: How a log file structure can affect database recovery timehttp://blogs.msdn.com/psssql/archive/2009/05/21/how-a-log-file-structure-can-affect-database-recovery-time.aspx#9642505Wed, 27 May 2009 01:38:40 GMT91d46819-8472-40ad-a661-2c78acb4018c:9642505Kendra Little<p>My understanding is that for large log files, shrinking the file down and then growing it back out in one operation can result in a different problem wherein there are too *few* VLFs for the database. I believe that this can result in problems clearing the log. I have been following Kimberly Tripp's recommendation to re-grow the log file in a given unit: <a rel="nofollow" target="_new" href="http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx">http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx</a></p> <p>Can you please comment on this?</p>