Home Forums SQL Server 7,2000 SQL Server Newbies How many log files will exist in a SQL Server Database with 4 secondary files? RE: How many log files will exist in a SQL Server Database with 4 secondary files?
george sibbald
SSC Guru
Points: 104210
More actions
August 19, 2013 at 3:56 pm
#1642885
log 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.
---------------------------------------------------------------------