Move a database between two hard drives

• Dfalir

  SSCrazy

  Points: 2486

  More actions

  January 11, 2007 at 6:54 am

  #193842

  Guys, i need your help....

  I want to tranfer a database from the c drive of my server to the d drive on the same server. Just change drives..

  can someone tell me how plz?

  its urgent

  thank you very much for your help..

   

  ---

  "If you want to get to the top, prepare to kiss alot of bottom"
  

• Mark Harr

  SSCrazy Eights

  Points: 9921

  More actions

  January 11, 2007 at 7:32 am

  #682678

  Easiest way for me to do this is just detach the database, move the files, then re-attach the files.  You can detach it in EM, but you will not be able to re-attach it if you have over a certain number of files (5 or 7 if memory serves me, but I don't have SQL 2000 anymore to check).  If so, check on using the sp_attach_db procedure.

  If this is for permanent configuration, and you want all new databases to also be on the D: drive, make sure you change default file location on the server properties window.

  Hope this helps

  
  
  Mark

• Johan Bijnens

  SSC Guru

  Points: 134873

  More actions

  January 11, 2007 at 2:44 pm

  #682783

  just to add ...

  there are special procedures to move master, model, tempdb and msdb.

  check out bol or msdn (I cannot recall the KB wright now)

  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