SQL Server Performance

The status of the mirror database

Discussion in 'SQL Server 2005 Database Mirroring' started by xiebo2010cx, Feb 14, 2007.

  1. xiebo2010cx New Member

    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
    ------------------
    xiebo2010cx, Feb 14, 2007
    #2

  2. satya Moderator

    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, Feb 14, 2007
    #2

  3. xiebo2010cx New Member

    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
    ------------------
    xiebo2010cx, Feb 14, 2007
    #2

  4. satya Moderator

    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.
    satya, Feb 14, 2007
    #2

Share This Page