December 21, 2012 at 1:41 pm
If the mirroring is configured with Asynchronize Operation mode, how does the principal database looks like.
Meaning, DatabaseName (Principal, Asynchronized) or it will still shows as DatabaseName (Principal, Sychronized)
Thanks,
SueTons.
Regards,
SQLisAwe5oMe.
December 22, 2012 at 9:16 am
It will show as synchronized - that indicator does not tell you the mode of mirroring but the state of the mirroring process and whether or not the mirrored database has all of the transactions applied or not.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 22, 2012 at 10:14 am
Principal, Synchronized or Principal, Synchronizing, depending whether the mirror is behind or up to date.
Asynchronised is not a word, the negation to synchronised would be unsynchronised.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply