 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / July 2008Master and master_log in different drives
Is it a good practice separate master.mdf and master_log.ldf in different drives? If yes, how? Thanks, Felipe There is really no spceicially good reason for separating the master mdf file and master ldf file to different drives. There aren't many changes on the master database, and you can't use its log for point in time recovery anyway. It's simpler to just put them in the same place. Linchi > Is it a good practice separate master.mdf and master_log.ldf in different > drives? [quoted text clipped - 3 lines] > > Felipe Make sense. Thanks Lichi! > There is really no spceicially good reason for separating the master mdf > file [quoted text clipped - 12 lines] >> >> Felipe Is there any system database that needs to have MDF and LDF in different drives to improve performance, such as Tempdb? Thanks, Felipe > Make sense. > [quoted text clipped - 17 lines] >>> >>> Felipe TEMPDB files should be in different drives as recommended http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx > Is there any system database that needs to have MDF and LDF in different > drives to improve performance, such as Tempdb? [quoted text clipped - 25 lines] >>>> >>>> Felipe On Jul 7, 1:43 pm, "Carlos Felipe França da Fonseca" <carlosfelipefra...@gmail.com> wrote: > Is it a good practice separate master.mdf and master_log.ldf in different > drives? [quoted text clipped - 3 lines] > > Felipe read this article. it provides guide lines to move user db's and sys db's . http://support.microsoft.com/kb/224071 This article has some scripts that might prove to be helpful http://www.sqlservercentral.com/articles/Administration/2605/ note: u might need a login for sqlservercentral.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.