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

moving Model.mdf file on different drive and Model.ldf file on different drive Expand / Collapse
Author
Message
Posted Saturday, October 19, 2013 11:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 8:59 AM
Points: 7, Visits: 28
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
Post #1506441
Posted Sunday, October 20, 2013 4:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:35 PM
Points: 6,829, Visits: 13,291
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
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #1506464
Posted Sunday, October 20, 2013 10:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 8:59 AM
Points: 7, Visits: 28
Thanks for you prompt reply..yes.. just i did it..:)
Post #1506485
Posted Sunday, October 20, 2013 12:45 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:16 AM
Points: 39,980, Visits: 36,346
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 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 #1506497
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse