Wednesday, March 28, 2012

Mirror goes down... Affect client transactions?

If the mirror server goes down for any reason, then what happens to client transactions against the principle?

Will any client transactions fail?

Thanks in advance

Quick answer - no, they should not be affected.

However, if you have witness set-up and the principal cannot connect to both the witness and the mirror then it will stop serving the database and the transactions will fail.

Take a look at this article:

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx#ETPAE

Thanks,

Kaloian.

|||

Thank you. That answers my question.

No comments:

Post a Comment