Sql server mirroring disconnected

  • Our internet at one of our sites ended up going down for an extended period of time (most of a day). When it came back online sql db mirroring was in a disconnected state and it wasn't immediately apparent how to bring it back online. I've started working on copying the backups over to the mirror server, but some of the databases are getting large enough that it now may take a day to copy a full backup over the WAN.

    Is there anyway to tell mirroring to reconnect? I tried the set partner script but it still has an associated partner.

    EDIT:

    more information

    SELECT *

    FROM sys.database_mirroring_endpoints

    state_desc reports as STARTED

  • The answer is, run this on each endpoint:

    ALTER ENDPOINT YourDBMirrorEndPoint STATE = STARTED

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

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