Moving SQL Logfiles

• Paul roy

  Grasshopper

  Points: 16

  More actions

  June 9, 2004 at 12:15 pm

  #152179

  Not sure if this is the correct place for this question..

  How do I move the location of my logfiles?  This is the default installation and still in development.

   

  Thx

• Johan Bijnens

  SSC Guru

  Points: 135369

  More actions

  June 10, 2004 at 12:15 am

  #509767

  With Query Analyzer or EM : sp_detatch_db 'yourUserdb'

  With explorer move the file to the correct location.

  With Query Analyzer or EM : sp_attach_db 'yourUserdb', 'FileLocationAndName.MDF', 'FileLocationAndName.Ldf'

  For system databases check http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b224071

  Maybe even adjust the default filelocations for new DB in EM. (ServerProperties\Database settings)

   

   

   

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• davidf

  Right there with Babe

  Points: 787

  More actions

  June 10, 2004 at 6:56 am

  #509831

  Just created a new system this week. I used the same methods alzdba recommends.

• Paul roy

  Grasshopper

  Points: 16

  More actions

  June 10, 2004 at 7:58 am

  #509862

  Alzdba,

  Thank you very much for your help.  I was successful in completing the procedure as per your recommendation.

   

  Thanks again.