Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what is replication?
where do u use Go Keyword?

Question Posted / sam


what is replication? where do u use Go Keyword? ..

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

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL Server Interview Questions

can an order by clause be used in a creation of a view?

0 Answers  

How to sort query output in descending order in ms sql server?

0 Answers  

What is data modification?

0 Answers  

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

What are secondary xml indexes?

0 Answers  

Explain different types of locks in sql server.

0 Answers  

What do you understand by SQL*Net?

0 Answers   Tech Mahindra,

What are the character string functions supported by sql server 2005?

0 Answers  

What is check constraint in sql server?

0 Answers  

How do clustered indexes store data?

0 Answers  

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  

Define model database?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories