how we can move file from one drive to another drive in sql server RRS feed

  • Question

  • HI

    it may be a simple question .i am a self learner don't mine 

    advance thanks

    plz help me

    Monday, September 3, 2012 6:49 AM


All replies

  • Hello,

    You can use the detach/attach methode to move your database, but for this you need a downtime for the database.

    See Move a Database Using Detach and Attach (Transact-SQL)

    Olaf Helper
    Blog Xing

    • Proposed as answer by Ramesh Babu Vavilla Monday, September 3, 2012 10:12 AM
    • Marked as answer by Rpreddy Monday, September 3, 2012 10:17 AM
    Monday, September 3, 2012 7:15 AM
  • Simple you can use Backup/restore (use Move option) and attach/detach method-

    see below-


    Move User Databases

    Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they help and un-mark them if they provide no help.

    Monday, September 3, 2012 10:07 AM
  • thanks olaf
    Monday, September 3, 2012 10:17 AM