Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Secondary server to change the another location? Expand / Collapse
Author
Message
Posted Tuesday, October 15, 2013 1:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 8:55 PM
Points: 1,076, Visits: 3,054
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
Post #1504626
Posted Tuesday, October 15, 2013 6:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:55 AM
Points: 6,752, Visits: 14,397
are you asking how to failover to the mirror database?

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1504707
Posted Tuesday, October 15, 2013 7:50 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:57 AM
Points: 5,888, Visits: 13,062
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.


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

Post #1504758
Posted Tuesday, October 15, 2013 10:49 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 8:55 PM
Points: 1,076, Visits: 3,054

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.
Post #1505066
Posted Wednesday, October 16, 2013 2:54 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:57 AM
Points: 5,888, Visits: 13,062
Perry, can you confirm my post is visible please?



Ananda, if it is, see my post


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

Post #1505113
Posted Wednesday, October 16, 2013 4:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:55 AM
Points: 6,752, Visits: 14,397
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


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1505134
Posted Wednesday, October 16, 2013 5:39 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:57 AM
Points: 5,888, Visits: 13,062
phew, thank lord, thought it was just me

cheers.


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

Post #1505149
Posted Wednesday, October 16, 2013 7:01 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 8:55 PM
Points: 1,076, Visits: 3,054

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
Post #1505171
Posted Wednesday, October 16, 2013 7:03 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:57 AM
Points: 5,888, Visits: 13,062
are you clear on the steps?, what you suggested is ok.

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

Post #1505172
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse