Post reply

mirror failover

  • December 28, 2008 at 5:38 pm

    #199402

    Hi Folks,

    I have an issue with a mirror that I am testing in high safety mode.

    I am testing what happens when I shut down the principal while transactions are running.

    on the principal I run the script:

    use [test]

    GO

    declare @testint int

    set @testint=0

    while (1=1)

    begin

    print @testint

    set @testint = @testint + 1

    update testload

    set testint = @testint

    where testtxt = 'test'

    print @testint

    end

    After 10 secs or so I run SHUTDOWN WITH NO WAIT command on the principal

    The update count on the principal is 62736 (val for @testint) but on the mirror (before failover) it is higher at 62761.

    I would have thought it would have been lower or the same as it seems there are 25 extra updates (62761-62736)

    that have been run on the mirror but not the principal

    Does anybody know what is happening?

  • January 2, 2009 at 6:18 am

    #920225

    I would hazard a guess that the transactions have been committed on the Mirror, but not yet committed on the Principal. When the Principal database is brought back online, I would think these transactions will be rolled-forward, thus bringing the Principal back in line with the Mirror.

    Can you run a few tests and publish what you discover?

    Thanks,

    Andy

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

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