Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How many log files will exist in a SQL Server Database with 4 secondary files? Expand / Collapse
Author
Message
Posted Monday, August 19, 2013 3:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 19, 2013 5:01 PM
Points: 4, Visits: 11
How 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 - Richard
Post #1486032
Posted Monday, August 19, 2013 3:56 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:24 PM
Points: 5,847, Visits: 12,580
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.


---------------------------------------------------------------------

Post #1486037
Posted Monday, August 19, 2013 4:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 19, 2013 5:01 PM
Points: 4, Visits: 11
So 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, Richard
Post #1486039
Posted Monday, August 19, 2013 4:02 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:47 AM
Points: 41,525, Visits: 34,442
You only need one log file. You can create more, but there's very seldom a good reason to do so.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1486041
Posted Monday, August 19, 2013 4:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 19, 2013 5:01 PM
Points: 4, Visits: 11
Many Thanks!!!
Post #1486044
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse