CODEWITHSUNDEEP
sql-serversynchronization
pang
pang

Reputation: 4154

SQLserver Database Synchronization between two servers

Currently, I have two database servers (s1 and s2). both server contains the same database MyData and data only update on s1.

What I want to do is that I want both databases contains same data all the time in both server.

Could anyone point out the good way to do this without slowing down s1?

Upvotes: 1

Views: 2158

Answers (4)

Oleh
Oleh

Reputation:

not sure if you need to do it programatically but you can use MS Sync Framework. see more in http://msdn.microsoft.com/en-us/sync/default.aspx

Upvotes: 0

mrdenny
mrdenny

Reputation: 5078

You could use SQL Server Replication if you need to be able to read the data from S2. If you don't need to be able to read the data in S2 you can use Log shipping or database mirroring.

If you use database mirroring you can quickly and easily fail over from using s1 as the server to write to and use s2 as the server to write to.

Upvotes: 1

ChrisLively
ChrisLively

Reputation: 88044

log shipping is another option

Upvotes: 0

RBarryYoung
RBarryYoung

Reputation: 56725

SQL Server Replication

Upvotes: 2

Related Questions