Home Forums SQL Server 2008 SQL Server 2008 High Availability Database Mirroring scenario RE: Database Mirroring scenario

  • March 18, 2014 at 8:33 am

    #1698040

    zedtec (3/18/2014)

    In relation to this, what happens if one of the site's goes down (i.e - the principal site) and automatic failover is not being used (i.e. - there is no witness server).

    In this case, how would manual failover be done on the principal server if the entire server is down/disconnected from the mirror server?

    If failover is not done manually and automatic failover cannot be done anyway then what happens with mirroring?

    Does it continue running?

    Also what happens to the mirrored databases? I'm assuming they remain as mirrored and therefore inaccessible by users?

    Thanks.

    In this Scenario you can force the Mirror to become Primary. But there is a possibility of Data Loss.

    You can run this command ..

    ALTER DATABASE <databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

    Check this for better understanding\consequences ..

    http://technet.microsoft.com/en-us/library/ms189850.aspx

    --

    SQLBuddy