Default Database and Transaction log locations

• Carl Rimmer

  SSCarpal Tunnel

  Points: 4068

  More actions

  January 17, 2005 at 5:10 am

  #112934

  I am looking to set the default database locations on our sql servers to make it easier to roll out new databases through scripts.

  Do you need to stop and start the SQLSERVERSERVICE for this change to take effect?

  Thanks in advance

  Carl

   

   

   

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 17, 2005 at 5:49 am

  #537646

  Answered here:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=155849

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]