March 11, 2014 at 1:09 am
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
March 13, 2014 at 11:24 pm
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."
March 14, 2014 at 2:48 am
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" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply