dbTalk Databases Forums  

Expert Advice

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clients Expert Advice

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Expert Advice in the microsoft.public.sqlserver.clients forum.



Reply
Page 3 of 3 < 1 2 3
 
Thread Tools Display Modes
  #21  
Old   
Rogers
 
Posts: n/a

Default RE: Expert Advice - 07-04-2008 , 10:09 PM





thanks for your reply Linchi, let say I have db1 on server1 and it has merge
replication on db2 on server2 and transaction replication on db3 on server3,
now i want to create database mirroring on db1 from server1 and that has
mirror to db1 on server4? is it possible.

thanks


"Linchi Shea" wrote:

Quote:
1. Whether merge replication and active/active' configuration you described
make sense depends on your business requirements. For many apps that must
maintain a single copy of truth (e.g. your bank account), this would not make
sense.

2. Transactional replication should work for the scenario you described.

3. You can't use a database mirror for transactional/merge replication.

Linchi

"Noor" wrote:

Dear Professional,

I would like to ask couple of question in terms of Load Balancing,
Replication, Database Mirroring.

1. Our organization has two production servers, one is on Toronto and other
one is on New York. In New York I have five databases and Toronto I have
nine databases.

Now the requirement is I have to create two instance in New York box and top
of that we have to install F5 BIG IP so that we can use Load Balancing as
well as have to create Merge Replication so that both the instance would
work as Active Active...

Question, is there any other way we can use Active Active or the above
solution is the best one?

2. Now the requirment is if any thing update on New York Box then it has to
replicate on Toronto. I think Transaction Replication is the best solution?
Am I right? Is it possible if user want to retrive any data it calls the
data from Toronto box and if the user want to update the data the
application point to New York box and replicate the data to Toronto
automatically through Transaction Replication, is it possible?

3. A part from Merge Replication and Transaction Replication, I have to
create Data Mirroing for Disaster Recovery, Is is possible I can use same
database for Merge Replication and Database Mirroring ?

I would appreciate if anyone help me out?

Thanks

Reply With Quote
Reply
Page 3 of 3 < 1 2 3

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top