Recreate Missing Log Files

• sathieshsql

  Mr or Mrs. 500

  Points: 531

  More actions

  February 26, 2014 at 12:05 pm

  #396335

  Comments posted to this topic are about the item Recreate Missing Log Files

  --

  Thanks & Regards,
  N.S.Sathish(SQL DBA)

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  March 13, 2014 at 3:58 am

  #1696684

  Correction: ATTACH_REBUILD_LOG will only create a single log file, no matter how many log files you had before.

  Beware that in all cases, you get a 0.5MB log file with two 0.25MB VLFs.

  Paul Randal
  CEO, SQLskills.com: Check out SQLskills online training!
  Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
  SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
  Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

• enriarg

  SSC-Addicted

  Points: 414

  More actions

  March 26, 2014 at 1:32 pm

  #1700448

  I am sorry for the newbie question but, why beware of the default creation of those files?

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  March 26, 2014 at 1:41 pm

  #1700450

  Don't apologize - everyone starts with zero knowledge about SQL Server.

  If the log file is created very small, it will have to autogrow back to the steady-state size. Each autogrow of a log file entails zeroing out the newly allocated portion of the log, which can be a perf hit on a busy system. Also, unless autogrow is set correctly, you could end up with many hundreds or thousands of VLFs, which can cause a bunch of performance issues too.

  Check out my wife's blog post at http://www.sqlskills.com/blogs/kimberly/transaction-log-vlfs-too-many-or-too-few/

  Cheers

  Paul Randal
  CEO, SQLskills.com: Check out SQLskills online training!
  Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
  SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
  Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

• enriarg

  SSC-Addicted

  Points: 414

  More actions

  March 26, 2014 at 4:12 pm

  #1700495

  Thanks Mr, Randal sorry thats my way of speaking.

  I see, I was already aware of this and have read in the past your wife post, but I was under the impression I was probably missing something.