Post reply

failing back a mirrored database after restoring the master

  • January 4, 2009 at 9:39 pm

    #204706

    Hi Folks,

    I was running through a scenario which my master database is corrupt and I want to failover to the mirror. I did this by

    ALTER DATABASE SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS on the mirror

    I then rebuilt the master db

    start /wait

    I then restored the master database.

    After bringing the database instance up the databases came back in a mirrored state. When I tried to resume mirroring though I kept getting synchronizing status; which was weird because there was noone using the database. so I broke the mirror and tried to establish and I got

    error 1443; severity 16 state 2

    Why can't I synchronize?

  • January 4, 2009 at 9:50 pm

    #920955

    after restarting the mirror (old principal) again and resuming mirroring the databases synchronized. Weird :hehe:

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

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