January 13, 2009 at 8:26 am
Can a log file have extension other than ".ldf"
And what is its impact ? How will sql server recognize it as a log file ?
January 13, 2009 at 10:09 am
You can call it whatever you want, the information is stored within SQL as to what it is. It's just simpler to keep it that way for identification purposes (not to mention a best practice recommendation)
January 13, 2009 at 10:09 am
You can, for example, add as many log files as you want to a database and give them whatever extension you want. Same thing with the mdf file: many people have a second data file called, quite often, .ndf.
January 13, 2009 at 11:23 am
Whisper9999 (1/13/2009)
You can, for example, add as many log files as you want to a database and give them whatever extension you want.
Thought it's not usually a good idea to have multiple log files. There's no gain in using them (they're written sequentially, not in parallel)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply