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 the diffrence between Snap Shot and Transaction
Replication

Question Posted / bhaskar

Answers were Sorted based on User's Feedback



what is the diffrence between Snap Shot and Transaction Replication..

Answer / hari

Snapshot is the a picture or snapshot of the databse is
taken peridicalloy propgated to the sbuscripber.
it does't invole continuesly.

only read only

transcation replication : This can be used to replication
changes to the database with this any changes made to the
replication data immediately caputred from transcation log
and propogated to the distributor

Is This Answer Correct ?    6 Yes 2 No

what is the diffrence between Snap Shot and Transaction Replication..

Answer / gowtham

In snapshot replication we ccan take the copy of the database
from publisher and put it into the subscriber,here it is in read-only mody it will not allow us to make any modifycations

In Transactional replication it is a oneway commite if we did any modifications in publisher those modifications will be replicated to suscriber (here the log rederagent captures the
changes in suscriber from transactional log and it moves to the distibutor).

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Write a SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

What is inner join? Explain with an example?

0 Answers  

how you can move data or databases between servers and databases in sql server? : Sql server administration

0 Answers  

How to get the definition of a stored procedure back?

0 Answers  

What is the system function to get the current user's user id?

2 Answers   HCL,

What is the difference between char and varchar2 datatype in sql?

0 Answers  

How to count duplicated values in a column in ms sql server?

0 Answers  

What is temporal table?

0 Answers  

What is an extended Stored Procedure?

1 Answers  

What is update locks?

0 Answers  

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

What is tcl in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories