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

Database Mirroring - Principal Disconnected and FULL Backups Expand / Collapse
Author
Message
Posted Tuesday, March 11, 2014 1:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 25, 2014 5:48 AM
Points: 35, Visits: 496
Hi,

There are 2 server A (principal) and B(Mirror) -Synchronous Mode without automatic fail-over. When principal A goes down Mirror B database is brought up using command

ALTER DATABSE SET PARTNER FORCE_SERVICE_DATA_LOSS

A(earlier principal) is down for 5 days. In this 5 days FULL , DIFF and Trn backup is taken at B(earlier Mirror). After 5 days when A(earlier Principal) is up
then whether the database backup taken at B(earlier mirror) will affect
database mirroring

Thanks and Regard,
Nikhil Desai
Post #1549579
Posted Thursday, March 13, 2014 11:24 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
What is the status on serverA sync with ServerB? Not sure how is your database on serverA? Refer following link which might help you.

http://technet.microsoft.com/en-us/library/ms189850.aspx

HTH


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1551011
Posted Friday, March 14, 2014 2:48 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:41 PM
Points: 6,349, Visits: 13,670
nikhil.desai1 (3/11/2014)
Hi,

There are 2 server A (principal) and B(Mirror) -Synchronous Mode without automatic fail-over. When principal A goes down Mirror B database is brought up using command

ALTER DATABSE SET PARTNER FORCE_SERVICE_DATA_LOSS

A(earlier principal) is down for 5 days. In this 5 days FULL , DIFF and Trn backup is taken at B(earlier Mirror). After 5 days when A(earlier Principal) is up
then whether the database backup taken at B(earlier mirror) will affect
database mirroring

Thanks and Regard,
Nikhil Desai

Funny someone else asked this exact same question the other day and was told the answer.

No, the backups would not affect, why would you think that they do?
What will happen is that when the old principal comes back it will rejoin the session as the new mirror and the session will be suspended. You will need to issue the following command to resume the session

alter database [yourdb] set partner resume



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

"Ya can't make an omelette without breaking just a few eggs"
Post #1551054
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse