SQL Server Performance

mirror server reboot or sqlserver restart

Discussion in 'SQL Server 2005 Database Mirroring' started by priyaram, Aug 22, 2007.

  1. priyaram New Member

    will be the mirroring between principal and the mirror server will be disconnected , when we reboot the mirror server or when we restart the sqlserver ??
    priyaram, Aug 22, 2007
    #2

  2. thomas New Member

    Yes it will be disconnected while the mirror server reboots or the service restarts. Log sends will queue at the principal and mirroring will catch up again once the mirror comes back online.
    thomas, Aug 23, 2007
    #3

  3. satya Moderator

    If the Mirror server instance is restarted then REDO queue log increases, so ensure you have proper sizes allocated to teh transaction log too.
    satya, Aug 23, 2007
    #4

  4. priyaram New Member

    Actually i restarted the service in the mirror server , but after the server come back also, the mirror is in disconnected state with the principal..
    is there any other reasons for this...
    priyaram, Aug 23, 2007
    #5

  5. satya Moderator

    Checked the error log on Principal & Mirrored servers?
    satya, Aug 24, 2007
    #6

Share This Page