February 21, 2008 at 5:41 am
Hi,
What is it I must take into consideration when deciding hoe many file a log file must have for a database?
February 21, 2008 at 6:33 am
basically its as simple as how much room you have. Log files do not stripe data like data files do, sql will fill the first log file, then move onto the next. The only reason you should need more than one is if you run out of space and want to continue on another drive.
February 27, 2008 at 10:37 am
It depends on the number of transactions, size of transaction, recovery model, usage of temporary objects, etc. Also depends on the size of the table.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 28, 2008 at 3:38 pm
What you dont want is to have many virtual log files
February 28, 2008 at 8:33 pm
It depends on the data change activities (insert/update/delete), change volume in one single batch, and transaction log backup frequency, reindex in place or not (full recovery mode).
Usually set it 20% of the data file. But it really depends.
February 28, 2008 at 9:13 pm
One per database unless you have space issues.
March 1, 2008 at 10:12 pm
One per database unless you have space issues.
Agreed. There is no real advantage to adding additional log files. Adding more log files is usually a means to spread out disk space.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply