SQLServerCentral.com / SQL Server Newbies / SQL Server 7,2000 / How many log files will exist in a SQL Server Database with 4 secondary files? / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 31 Mar 2015 15:30:43 GMT20RE: How many log files will exist in a SQL Server Database with 4 secondary files?http://www.sqlservercentral.com/Forums/Topic1486032-169-1.aspxMany Thanks!!!Mon, 19 Aug 2013 16:05:03 GMTRickNPHXRE: How many log files will exist in a SQL Server Database with 4 secondary files?http://www.sqlservercentral.com/Forums/Topic1486032-169-1.aspxYou only need one log file. You can create more, but there's very seldom a good reason to do so.Mon, 19 Aug 2013 16:02:53 GMTGilaMonsterRE: How many log files will exist in a SQL Server Database with 4 secondary files?http://www.sqlservercentral.com/Forums/Topic1486032-169-1.aspxSo then, the one log file keeps track of all changes to MDF's, and NDF's. That means the log record must have info about which file is being affected with each transaction. thanks, RichardMon, 19 Aug 2013 16:00:49 GMTRickNPHXRE: How many log files will exist in a SQL Server Database with 4 secondary files?http://www.sqlservercentral.com/Forums/Topic1486032-169-1.aspxlog files are written to sequentially, therefore there is only a need for 1 log file, no matter how many data files.there is no performance gain to multiple log files.Mon, 19 Aug 2013 15:56:40 GMTgeorge sibbaldHow many log files will exist in a SQL Server Database with 4 secondary files?http://www.sqlservercentral.com/Forums/Topic1486032-169-1.aspxHow many log files will exist in a SQL Server Database with 4 secondary files in addition to the primary file - (irrespective of physical location)? I would expect there to be 5 log files, one for each data file, but not sure. On MS site, I saw some info that confused me a little. thanks - RichardMon, 19 Aug 2013 15:40:32 GMTRickNPHX