SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Moving storage (SAN hp -> eva) with SQL Mirroring


Moving storage (SAN hp -> eva) with SQL Mirroring

Author
Message
saqlainkhan
saqlainkhan
SSC Journeyman
SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)

Group: General Forum Members
Points: 82 Visits: 422
We have a request come in to have the storage moved form HP--> EVA. The server that is part of this has SQL Mirroring on this.

What will be the best way to to this
1)as storage admin has requested to break mirroring
2)application folks don't like that idea since they have mirroring setup and would like to use this without any downtime

Expected time needed by the Storage Admin ~ 1hr.

SQL Stnd Edition 2008
# of Databases - 5
Mirroring safety lvl - Full

Thank you in advance!

Noli Timere
Perry Whittle
Perry Whittle
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21031 Visits: 17246
saqlainkhan (7/15/2013)
We have a request come in to have the storage moved form HP--> EVA. The server that is part of this has SQL Mirroring on this.

What will be the best way to to this
1)as storage admin has requested to break mirroring
2)application folks don't like that idea since they have mirroring setup and would like to use this without any downtime

Expected time needed by the Storage Admin ~ 1hr.

SQL Stnd Edition 2008
# of Databases - 5
Mirroring safety lvl - Full

Thank you in advance!

They want you to break mirroring while they move the storage?
What are they moving, just the mirror instances storage or the principal too?
Are they moving the LUNs between EVAs?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
saqlainkhan
saqlainkhan
SSC Journeyman
SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)SSC Journeyman (82 reputation)

Group: General Forum Members
Points: 82 Visits: 422
[/quote]
They want you to break mirroring while they move the storage?
YES
What are they moving, just the mirror instances storage or the principal too?
THEY ARE MOVING JUST THE MIRRORED
Are they moving the LUNs between EVAs?
NO[/quote]

Noli Timere
vultar
vultar
Old Hand
Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)

Group: General Forum Members
Points: 397 Visits: 1217
Think you'll need to break the mirroring because you won't be able to move the storage for the db - unless the Eva's can do this in the background (ones I've used couldn't).

Maybe suggest doing this work out of hours or at a quiet time as a compromise ?

Cheers

Vultar
Perry Whittle
Perry Whittle
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21031 Visits: 17246
saqlainkhan (7/16/2013)

They want you to break mirroring while they move the storage?
YES
What are they moving, just the mirror instances storage or the principal too?
THEY ARE MOVING JUST THE MIRRORED
Are they moving the LUNs between EVAs?
NO[/quote][/quote]
so all you need to do is ensure that safety is set to full, remove the witness temporarily if you are using one and pause the mirror session. Keep an eye on the principal transaction log size.

The storage admins should be able to mirror the present LUN to the new storage and break this mirror at the last moment once it is synchronised on both storage systems.

Just resume the SQL mirror session once the mirror instance is back online

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search