Answer / jijo

Synchronizing data and object between systems .

For example i have 50gb data in Delhi server(Publisher or
source ) i need to replicate into tow locations one into
mumbai server 10gb data (subscriber ) and another one into
kerala server 20gb data.

Publisher ---Source
Subscriber ---destination
Distributor--- Receive from publisher and forward to sub

Type of replications

1)Snapshot (one way)
Data refresh of the subscriber every time you synchronize.

2)Merge Replication (Two way)
Both publisher and subscriber can make change to the data.
Conflict :- When two participant chenge the same row at same
time

3)Transactional replication
As change made at the publisher its send to the distributor
and distributor into subscriber

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  

---

Is sql server is free?

0 Answers  

---

how many bits ip address consist of? : Sql server database administration

0 Answers  

---

How do I create an extended event in sql server?

0 Answers  

---

What are the different types of backups that exist?

0 Answers   ADITI,

---

What do you think of this implementation? Can this be implemented better?

0 Answers  

---

Differences between Standby Vs No recovery?

2 Answers   Wipro,

---

What is shrink log file?

0 Answers  

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

---

What is multi-statement table-value user-defined function?

0 Answers  

---

How to see existing views in ms sql server?

0 Answers  

---

How do I delete a sql server database?

0 Answers  

---