Post reply

Transition state of a Database

  • June 7, 2014 at 1:02 am

    #289770

    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.

  • June 7, 2014 at 2:44 am

    #1719898

    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[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply