locked
sql disk migration RRS feed

  • Question

  • Hi,

    I am looking for a bit of advice, discussuion on what i am going to do.  I have two sql server 2008 (not r2).  These servers are mirrored and one of the servers is the primary db server.

    The disks that the Databases are on are running out of space so we have purchased larger disks and configured them in the san.  The new disk cant be used to expand the existing drives.  What i am going to have to do is create two new disks in the san and present this to the two servers and move the databases to the new disks

    one question i have is, do i have to dsable the mirror before i attempt what i am going to do?  I am going to have to presnent the new disk, copy the database to the new disk (can i just use robocopy?), take the old disk offline and then give the new disk the same drive letter and then start sql again.

    does this sound about right?

    Any help much appreciated.

    Thanks

     


    phill
    Wednesday, February 9, 2011 3:10 AM

Answers

  • Phill,

    No Need to disable mirroring and make sure that the drive letter is same . anyways is fine it is not mandatory to use robocopy .

    ---------------------------
    Thanks,Suhas V

    • Marked as answer by Alex Feng (SQL) Wednesday, February 16, 2011 12:31 PM
    Wednesday, February 9, 2011 4:13 AM