Data + log folder structure changes

  • Hi all,

    We are migrating to a new server, of course we are splitting out log and datafiles, but otherwise, any best practice on folder naming?

    We were thinking of

    D:\SQLDATA

    L:\SQLLOGS

    Or does it make no difference??

  • Jake Shelton (2/14/2014)


    Hi all,

    We are migrating to a new server, of course we are splitting out log and datafiles, but otherwise, any best practice on folder naming?

    We were thinking of

    D:\SQLDATA

    L:\SQLLOGS

    Or does it make no difference??

    you can name them bob and fred if you want, makes no difference, obviously it would be best to name them in a way that identfies to which instance they belong

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Be consistent, be clear, be sensible (my rules for naming standards in general)

    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 3 posts - 1 through 2 (of 2 total)

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