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

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

0 Answers  

---

Tell me the difference between clustered and non-clustered index?

0 Answers  

---

What is the minimum recommended amount of ram for sql server 2012 enterprise?

0 Answers  

---

What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

How to view existing indexes on an given table using sys.indexes?

0 Answers  

---

Explain index in sql server?

0 Answers  

---

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

---

Explain indexed views?

0 Answers  

---

how would you troubleshoot blocking? : Sql server database administration

0 Answers  

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

---

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

---