July 15, 2009 at 7:15 am
Hi Experts,
I am new in this area and no nothing abt replication so.. i need your advise pls. we need to setup replication between 2 server. Our requirement is
1.Any database changes that happens in server 1 databases must be replicated to Server 2 and vice-versa.
2.People from L1 connect to Server 1 only and l2 connect to server 2. But If server 1 goes down then server 2 should be able to handle the user request and vice-versa.
3.Data integrity must be maintained
What he got
2 Power full server
100 Mg Ethernet direct link, our network delay is bit high..
SQL 2008 Std edition
What would be the ideal replication method to satisfy our need
Do I have to backup the server separately
Thanks
vinu
July 15, 2009 at 9:44 am
vinuvt (7/15/2009)
Our requirement is1.Any database changes that happens in server 1 databases must be replicated to Server 2 and vice-versa.
2.People from L1 connect to Server 1 only and l2 connect to server 2. But If server 1 goes down then server 2 should be able to handle the user request and vice-versa.
3.Data integrity must be maintained
What would be the ideal replication method to satisfy our need
Point 2 says there will be different set of users connecting to Server 1 and 2 both. Do you also mean that these users will be making changes to both the databases on both servers simultaneously? If yes, i suggest you go for Peer to peer replication. if you have identity columns on your tables, create seperate ranges for both databases.
Do I have to backup the server separately
yes, you have to backup both servers seperately. in the event of a crash or damage to the database, backups is the only option to recover, even tho u've setup replication!!
If all users can manage on server 1 only, You can go for mirroring with auto-failover. Please note that users wont be able to connect the mirrored database (not even for reading).
If users on server 2 connect the database for reading only, you can go for log shipping as well, however pls keep in mind that everytime a restore happens, your users will be disconnected. So this option might not be feasible in your case!!
July 15, 2009 at 10:19 am
Pradeep has good ideas, but this is rather complicated. You might want to hire someone to help you get this going.
You have two needs. Synchronizing databases, which requires some level fo replication, can be done. Whether merge or bidirectional transactional is better I'm not sure. You'd need to analyze things there, as well as set this up table by table. It's not a simple wizard that will do it all.
For failover, that's a completely separate issue. Mirroring can work, but clients may or may not automatically failover. You'd have to look at the client code.
The best thing is that you read up on how these items work and then ask questions about more specific items.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply