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

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

0 Answers  

Will sql server 2005 allow you to reduce the size of a column?

0 Answers  

What is sql sandbox in sql server?

0 Answers  

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

0 Answers  

Explain transaction isolation levels in sql server?

0 Answers  

Name 3 ways to get an accurate count of the number of records in a table?

0 Answers  

diffrence between Cluster Index and non Cluster Index

3 Answers   Wipro,

How can you insert null values in a column while inserting the data?

0 Answers  

How many categories of functions based their return modes?

0 Answers  

What stored by the msdb?

0 Answers  

What is the security principal at the database level that represents your session?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories