June 10, 2008 at 1:06 pm
One of our production systems has the databases spread across 2 SQL instances on a 2-node cluster. Can I configure the databases on both SQL instances to mirror to a single server (in High-Performance mode - no Witness server)?
The setup is a DR configuration- the business wants as little potential for data loss as possible (hence no Log Shipping), but with as little impact as possible (hence High-Performance / a-synch mirroring).
TIA for your help and advice ...
June 10, 2008 at 1:33 pm
So you have a split database ?? :ermm:
One part on node one and the other part on node two ??
This must be a very, very high trx volume db. :blink:
If the databases do not carry the same dbname, it will work.
Otherwise it cannot be done, because with db-mirroring, your dbname needs to be the same at the involved instances !
There are nice ms-docs for db-mirroring, and there is a best practise doc
I haven't got the urls for the moment.
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
June 10, 2008 at 1:47 pm
Thanks Al :smooooth:.
Actually, the app has multiple databases, which are spread across the two instances - its an email archiving app (for legal recovery) that covers that whole of North America for us. The other instances of the app around the world only have a single SQL instance, but this one has enough trx volume to warrant two SQL instances.
June 11, 2008 at 1:18 am
An option is to have your spare server hosting two sqlinstances, so you can use db-mirroring.
Keep in mind you'll have to duplicate jobs, instance level user admin, ...
the docs:
www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
Johan
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
June 12, 2008 at 1:33 pm
Thanks Johan.
I actually got my lazy self to go and do the research, and found this on MSDN
All database mirroring sessions support only one principal server and one mirror server.
(at http://msdn.microsoft.com/en-us/library/ms189852.aspx) which, while it doesnt explicitly rule out a 2-1 configuration, it does rule out the reverse 1-2 configuration, and therefore by implication it rules out the 2-1 configuration.
June 13, 2008 at 12:19 am
I did interprete the line as "you can only mirror a database to a single mirror".
I'm still doing some tests with it, and didn't test the scenario you aim for.
What's your actual need ?
You have a clustered solution in place, wich should allow you to have availability within +- 30sec.
Will having the extra hardware (for the mirror hosting box) and disk volume, speedy network, instance management, ... costs be justified for bringing data downtime towards +- 10 seconds ?
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply