Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transition state of a Database Expand / Collapse
Author
Message
Posted Saturday, June 7, 2014 1:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:06 AM
Points: 274, Visits: 1,466
Hi All,

What is the transition state of a DB and what happens in this phase?

There is a mirror setup in my environment. When I failing over the DBs to mirror server. This msg appeared i.e. database is in transition phase.

Thanks in advance.
Post #1578567
Posted Saturday, June 7, 2014 2:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 5:57 AM
Points: 33, Visits: 534
Hello,

I believe that message is just letting you know that your transitioning from Mirror to Principal role. What happens there is that your Mirror will roll forward the database, how long this will take depends on the DB activity and size of your redo queue, and then make it new Principal.

That's a bit simplified explanation though, I remember seeing MSDN article explaining all the phases in failover transition in more detail.


Mika Sutinen, Senior DBA
@SQLFinn on Twitter
Blogging at SQLStarters
Post #1578572
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse