October 15, 2013 at 1:18 am
Hi,
The following database HA already configured
Primary server
SQL SERVER 2008 R2 64 bit,
HA: Database mirroring
Witness: Not configured
Mirror Mode: High Performance
Failover: manual
Backup: Every 30 min Transaction Log backup configured in principal server
When move the secondary server to change another location then what are steps need to be follow on primary server? IP address and server name will be remaining same after moving the secondary server.
1.Just pause the mirroring session in primary server when shutdown the secondary server
2.Re-start the mirroring session after placed secondary server to another location; duration may be 8 hrs will take for placing another location.
Please confirm these steps are sufficient?
Thanks
ananda
October 15, 2013 at 6:27 am
are you asking how to failover to the mirror database?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 15, 2013 at 7:50 am
pausing not strictly necessary but yes those are the steps. Take a log backup just before you start.
The log of the primary will fill whilst the secondary is down so just make sure you have enough log space. If you run out of log space you will have to remove mirroring.
---------------------------------------------------------------------
October 15, 2013 at 10:49 pm
I am just asking secondary server movement to another location which was configured database mirroring setup?
what are the steps need to follow during movement activity? suggestion Pls.
October 16, 2013 at 2:54 am
Perry, can you confirm my post is visible please?
🙂
Ananda, if it is, see my post
---------------------------------------------------------------------
October 16, 2013 at 4:36 am
george sibbald (10/16/2013)
Perry, can you confirm my post is visible please?🙂
Ananda, if it is, see my post
your post is visible :hehe:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2013 at 5:39 am
phew, thank lord, thought it was just me
cheers.
---------------------------------------------------------------------
October 16, 2013 at 7:01 am
Mr. george sibbald your replay is most valuable..Pl. Do't mistake me, I am reply the Mr. Perry question
Perry Whittle (10/15/2013)
are you asking how to failover to the mirror database?
Thanks
October 16, 2013 at 7:03 am
are you clear on the steps?, what you suggested is ok.
---------------------------------------------------------------------
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply