locked
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

Answers

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-

    http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/5c0e5ba5-1e1a-4c38-ac92-3e5c50ac6c7b/

    Move User Databases
    http://msdn.microsoft.com/en-us/library/ms345483.aspx


    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