Post reply

Mirroring multiple databases on single instance.

  • June 10, 2014 at 3:45 am

    #287422

    I have to mirror 3 DBs on my sql server instance . I have restored there full backups and log backups on mirror.I have also created endpoints on principal and mirror using default ports 5022 and 5023.

    Could you please let me know if i can use the same endpoint for the databases on principal instance ? (If yes , it will be really helpful if you can give me steps or link to a article.)

  • June 10, 2014 at 6:07 am

    #1720346

    there is only one mirroring endpoint per instance, was that the question?

    ---------------------------------------------------------------------

  • June 10, 2014 at 6:12 am

    #1720350

    Thanks for your reply . If i go to add another endpoint it gives me below error :

    Msg 7862, Level 16, State 1, Line 1

    An endpoint of the requested type already exists. Only one endpoint of this type is supported. Use ALTER ENDPOINT or DROP the existing endpoint and execute the CREATE ENDPOINT statement.

  • June 10, 2014 at 6:21 am

    #1720355

    that would be expected, you are only allowed one mirroring endpoint.

    see http://msdn.microsoft.com/en-gb/library/ms175883(v=sql.110).aspx

    ---------------------------------------------------------------------

Viewing 4 posts - 1 through 3 (of 3 total)

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