Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Log architecture – multiple log files

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2008-05-22 : 14:03:13
When having multiple files for log, do they get filled one after the other (like Oracle) or proportionately fill?


------------------------
I think, therefore I am - Rene Descartes

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-22 : 14:09:46
Proportionately fill.


------------------------
Go to Top of Page

Haywood
Posting Yak Master

221 Posts

Posted - 2008-05-22 : 14:15:51
Logfiles are written to sequentially. There's not much of a benefit to having multiple logfiles (at least not in the same manner as having multiple datafiles).
Go to Top of Page
   

- Advertisement -