Post reply

Log File of a database

  • January 13, 2009 at 8:26 am

    #73431

    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

    #926049

    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)


    Shamless self promotion - read my blog http://sirsql.net

  • January 13, 2009 at 10:09 am

    #926050

    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

    #926115

    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

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply