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" 😉