February 26, 2014 at 12:05 pm
Comments posted to this topic are about the item Recreate Missing Log Files
--
Thanks & Regards,
N.S.Sathish(SQL DBA)
March 13, 2014 at 3:58 am
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
March 26, 2014 at 1:32 pm
I am sorry for the newbie question but, why beware of the default creation of those files?
March 26, 2014 at 1:41 pm
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
March 26, 2014 at 4:12 pm
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply