ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
What is database replicaion? What are the different types 
of replication you can set up in SQL Server?
 Question Submitted By :: Swapna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is database replicaion? What are the different types of replication you can set up in SQL Server?
Answer
# 1
Replication is the process of copying/moving data between 
databases on the same or different servers. SQL Server 
supports the following types of replication scenarios: 

Snapshot replication 
Transactional replication (with immediate updating 
subscribers, with queued updating subscribers) 
Merge replication 
 
Is This Answer Correct ?    16 Yes 0 No
Swapna
 
  Re: What is database replicaion? What are the different types of replication you can set up in SQL Server?
Answer
# 2
Replication is way of keeping data synchronized in multiple 
databases.SQL server
replication has two important aspects publisher and 
subscriber.
Publisher:
Database server that makes data available for replication 
is called as Publisher.
Subscriber:
Database Servers that get data from the publishers is 
called as Subscribers.
There are three types of replication supported by SQL 
SERVER:-
Snapshot Replication.
Snapshot Replication takes snapshot of one database and 
moves it to the other
database.After initial load data can be refreshed 
periodically.The only disadvantage of
this type of replication is that all data has to copied 
each time the table is refreshed.
Transactional Replication
In transactional replication data is copied first time as 
in snapshot replication , but later
only the transactions are synchronized rather than 
replicating the whole database.You
can either specify to run continuously or on periodic basis.
Merge Replication.
Merge replication combines data from multiple sources into 
a single central database.Again
as usual the initial load is like snapshot but later it 
allows change of data both on subscriber
and publisher , later when they come on-line it detects and 
combines them and updates accordingly
 
Is This Answer Correct ?    16 Yes 1 No
Purna Chandra Rao.k
 
 
 
  Re: What is database replicaion? What are the different types of replication you can set up in SQL Server?
Answer
# 3
Replication is a method of copying data from one database 
to other database or one server to another 

there are three types of replication 

(1) transactional (2)snapshot (3) merge (4) logshipping and 
in 2005 one more type is introducde which was called as 
peer to peer replications
 
Is This Answer Correct ?    1 Yes 5 No
Srisenthil
 
  Re: What is database replicaion? What are the different types of replication you can set up in SQL Server?
Answer
# 4
Replication is the technique provided by MS SQl server to 
keep the replicate copy of database.

There are four basis type of Replication which we can set 
up in sql server

1. Snapshot replication – It is used when data at Publisher 
is static means not changing frequently and Subscriber need 
update data

2. Transactional replication - It is used when data is 
changing frequently at publisher and Subscriber need on 
line data from publisher.

3. Merge replication- It is used when there is no constant 
connection between Publisher and Subscriber. When they come 
on line then data will       replicate. In replication data 
can conflict and resolve this there is rule set up already.

4. Transactional replication with Updateable Subscription-
   It is similer to Transactional replication but update 
backs to Publisher from Subscriber. In this it add extra 
field in table called ms_repl- etc to keep the update data 
from Subscriber.


  
We can also implement Peer to Peer replication which is 
Headless topology. To do this we need enterprise edition of 
sql server 2005. In this there is more than one Publishers 
and one or more Subscribers. Every participant is both 
Publisher and Subscriber. This is mostly use when every one 
wants to read and modify the data.
 
Is This Answer Correct ?    2 Yes 1 No
Neeraj Singh Bhandari
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How can i give the restrictions for the data entry, if i wish to enter only I ,II, III, IV in the grade actegory of student table?  3
What is a NOLOCK?  3
Can we call SP inside a query? Wipro4
sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??  1
what are the problems in logshipping?  2
why cluster and non clusterindex are used in sqlserver 2000? explain with example  1
how to replace double quotes by single quotes in sql server CAC2
What is a Trace frag?Where can we use this?  1
Difference between Function and Procedure-in general?  3
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.  4
Which system tables contain information on privileges granted and privileges obtained  1
What is difference between Triggers and store procedure?  2
What are the OS services that the SQL Server installation adds?  1
we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz  6
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?  2
what is the order of execution of where,having,group by in select stement Tanla-Solutions5
What should we do to copy the tables, schema and views from one SQL Server to another?  3
What are the two virtual tables SQL Server maintains for triggers?  2
Explain DBMS, RDBMS?  4
What are Magic Table? Evalueserve15
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com