patternsqlMinor
Mirroring in SQL Server Standard Edition
Viewed 0 times
sqlstandardmirroringserveredition
Problem
I have setup mirroring of a database in SQL Server Standard Edition.
After this I tried to see if the data has been synchronized or not.
I was not able to check data by taking a database snapshot since database snapshots are not available in SQL Server Standard Edition.
Is there any alternative solutions available to verify whether the data is synchronized or not?
After this I tried to see if the data has been synchronized or not.
I was not able to check data by taking a database snapshot since database snapshots are not available in SQL Server Standard Edition.
Is there any alternative solutions available to verify whether the data is synchronized or not?
Solution
Check the following system view:
There is a wealth of information in there about the status of your mirrored databases.
If the column
What
If it shows a status of
You can also use the Database Mirroring Monitor app to monitor the status of mirrored databases.
SELECT *
FROM master.sys.database_mirroring;There is a wealth of information in there about the status of your mirrored databases.
If the column
mirroring_state_desc contains 'SYNCHRONIZED' then it is indeed synchronized.What
SYNCHRONIZED indicates is that all outstanding transactions from the master have been successfully committed into the mirror database.If it shows a status of
SYNCHRONIZING then the mirror is "behind" the principal to some degree.You can also use the Database Mirroring Monitor app to monitor the status of mirrored databases.
Code Snippets
SELECT *
FROM master.sys.database_mirroring;Context
StackExchange Database Administrators Q#76302, answer score: 6
Revisions (0)
No revisions yet.