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

Do you know the isolation level that sql server support?

0 Answers  

---

What is 'write-ahead log' in sql server 2000 ?

0 Answers  

---

What are tables in sql server?

0 Answers  

---

How data can be copied from one table to another table?

0 Answers  

---

Define outer join?

0 Answers  

---

What are the different types of replication? How are they used?

3 Answers  

---

What is a sql join?

0 Answers  

---

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

---

What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  

---

What is mean by candidate key?

0 Answers  

---

What's the purpose of Stored Procedure?

6 Answers   Wipro,

---

what are different types of raid configurations? : Sql server database administration

0 Answers  

---