database sync in ms sql server

Answer is based on if you have 2 server with Microsoft SQL Server 2012.

Always On is the feature provided in SQL Server 2012 and above;however in previous versions it is called as HADR i.e.(High Availablity and Disaster Revcovery).
HADR is renamed as Always on.
High Availablity :- How your server is highly available if you say,
99.99%
99.999% 5 times nine means its highly available so to make the system Highly available we used following Disaster Recovery technique,
1] Clustering
2] Replication
3] Log Shipping
4] Mirroring

1] Clustering :- There are 2 servers 1 is Primary and 2nd is Secondary, when Primary server goes down secondary comes up and still application server is workable. But if storage server goes down then its failed no server is abvailable one of the dissadvantages.

2] Replication :- 2 Servers, Primary Replica and Secondary Replica it uses snapshot to setup DB Server and uses transaction to be replicated to sync DB's. but still there are some lagging in the transaction because of some time difference.

3] Log Shipping :- 2 servers, Kipping database sync with log backups.taking log backup every 5 mins/3 mins and restoring it on secondary server to make db in sync mode however if the server goes down in between these 5-3 mins then that tranaction will be gone.

4] Database Mirroring :- 2 Server, Principle Server (primary) and Mirroring Server (secondary). there are two types Synchronous and Asynchronous. for synchronous server required high bandwith network. as soon as record comes in Principle server and then it commited in Mirror Server. However in Asynchronous server can work on low bandwith network speed. when records comes in primary server that will be committed there and queued for Mirror server as per the network availablity it get committed on Mirror Server.

so its all up to your requirement you can make database sync mode with above ways.

hi,
Had you go through the data replication mirroring feature?

Assume that client and server both have independent database and it is MS SQL.

hi,

Database replication and mirroring feature may help you to sync up database in two different server

Please refer
http://msdn.microsoft.com/en-us/library/ms151198.aspx
http://msdn.microsoft.com/en-IN/library/ms189852.aspx

hope this will help you.

Hey kamal,

Can you elobrate your question please?
,means what you  want exzactly ,you want to get data from two different server of same type like ms SQL server .ya  you want to get data from two different type of server like oracle and SQL server.


Then we provide proper solution what you want.
Hope you understand.








Regards,


Abhijit Patil
Dotnetbyabhipatil.blogspot.in