Post reply

moving Model.mdf file on different drive and Model.ldf file on different drive

  • October 19, 2013 at 11:41 pm

    #284734

    Hello everyone,

    I have some doubt regarding moving .mdf file on other drive and .ldf file ob other drive.

    Can we keep .ldf file on different drive and .mdf file on different drive for MODEL database??

    Please suggest.

    Regards

    Ajay

  • October 20, 2013 at 4:41 am

    #1659962

    Yes, it's possible to have mdf and ldf files on different drives, including the MODEL database.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • October 20, 2013 at 10:58 am

    #1659980

    Thanks for you prompt reply..yes.. just i did it..:)

    🙂

  • October 20, 2013 at 12:45 pm

    #1659989

    For Model, that's overkill. The database is only used as a template to create other databases (including TempDB), so it should never see any load, so it shouldn't need anything doing to its files. Just stick it with master.

    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