mirroring

  • hi guys,

    If you have multiple databases on an instance that you want mirrored do you need to have separate endpoint for each one?

  • BOL:

    All mirroring connections on a server instance use a single database mirroring endpoint.

  • bodhilove (8/24/2008)


    hi guys,

    If you have multiple databases on an instance that you want mirrored do you need to have separate endpoint for each one?

    No. They use the a single end point.

    Be aware you there is no dependency between the databases, so their primary may be hosted on server1 for dbA and server2 for dbX

    IMO you should build in (WMI) event triggers at least to get notified if a db is switched primary/mirror !

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • that ok .. I plan on using manual failover anyway.

  • If you can, spend some time really getting to know mirroring. Once you do, it will be your friend. It makes upgrades, etc. much easier.

    The more you are prepared, the less you need it.

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

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