We'll see this if we try to failover the mirroring session when the databases are not in a SYNCHRONIZED state. Makes sense.. if you take a look at this post, you'll see the step before the manual failover was to resume the Mirror session. It just wasn't completely synchronized yet.
To confirm how far behind the mirror was, I ran this query on both the Principal and the Mirror.
SELECT
DB_NAME(database_id) [Database],
mirroring_failover_lsn
FROM
sys.database_mirroring
See this for more detail on sys.database_mirroring and the LSN:
And this for instructions on performing the manual failover via tSQL:
https://msdn.microsoft.com/en-us/library/ms179481.aspx
https://msdn.microsoft.com/en-us/library/ms179481.aspx
No comments:
Post a Comment