as we are in the process of expanding of businees, now we are stepping a ahead to add few more datacenter, now we have a requirement where we need to sync the production database with other datacenter servers, with few requirements. Here are the present server setup configuration as follows ( 2 servers)
- Server : Microsoft Windows Server 2008 R2.
- .net Framework : Microsoft .net framework 3.5
- IIS 7.5
Scenarios
How do we sync the production database to other server. is there any automation, replication method to perform the action, i.e whenever one record or some transaction happen it should sync to other server. i am wondering how people achieve efficiently.
Can we replicate or sync only table's which we mention, i.e in our DB Schema, there are some table, which we can ignore the syncing operation.
Is there any suggestion to improve the syncing operation or how other people deal with this scenario? is there any work arounds ? i heard of mirroring , but i don't know how to implement in this scenario.
i apperciate anybody guide us to build a successful story..