July 15, 2013 at 10:06 am
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!
July 16, 2013 at 12:24 am
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" 😉
July 16, 2013 at 12:49 pm
[/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]
July 18, 2013 at 2:53 pm
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
July 19, 2013 at 5:51 am
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" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply