August 24, 2008 at 9:07 pm
hi guys,
If you have multiple databases on an instance that you want mirrored do you need to have separate endpoint for each one?
August 25, 2008 at 7:41 am
BOL:
All mirroring connections on a server instance use a single database mirroring endpoint.
August 25, 2008 at 7:56 am
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
August 25, 2008 at 9:45 pm
that ok .. I plan on using manual failover anyway.
August 28, 2008 at 7:06 am
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