The status of the mirror database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

The status of the mirror database

From the management studio, it shows that the mirror database is ‘(Mirror, Synchronized / Restoring…)’, then I checked the status, it is not ‘readonly’, not ‘standby’, not ‘inLoad; …. So what is the db status of the mirror db? ——————
Bug explorer/finder/seeker/locator
——————
That means: The mirror database contains the same data as the principal database. Manual and automatic failover are possible only in the synchronized state.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Satya, I am trying to re-point my app to mirror db if something happens to principal db. For example: IF(failover happens)
Operations apply to mirror db
Else
Operations apply to principal db How to test when the "failover happens"
——————
Bug explorer/finder/seeker/locator
——————
http://msdn2.microsoft.com/en-us/library/ms186348.aspx follow this. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>