moving mirrored databases to a new lun

Question

Guys I have mirrored SQL server 2008 boxes I need to move the the databases over to a set of new luns. My question is do I need to break the mirror before moving the databases over to the new lun basically I'm asking what is the proper process when moving mirrored databases to a new set of disk.

Answer 1

If the drive letter and paths will be the same, then you do not need to break mirroring. This is how you can do it without breaking mirroring:

Let's assume that my data files are on H:\ drive and my log files are on O:\.

1. Add 2 new luns as I:\ and P:\ (or some unused letters)
2. Create the directory structures and copy all files that are not in use
3. Stop SQL Server service on Mirror
4. Copy the database files to new luns
5. Rename old luns to some new unused letters
6. Rename new luns to H:\ and O:\
7. Restart the SQL Service

---

---

My blog: SQL Soldier
Twitter: @SQLSoldier
Microsoft Certified Master: SQL Server 2008
My book: Pro SQL Server 2008 Mirroring

Answer 2

alphabanks

 

If you do need to keep old LUNs, you can just use Robert's method to move mirrored and system databases, and get everything else to "NEW" (Old LUN, new drive letters) using normal deattch/attach way.

---

Sevengiants.com

Answer 3

Actually guys the mirrored databases will stay there current storage I'm going to be moving the principle databases however I assume I can use the above method to move the principal as well.