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

Define outer join in sql server joins?

0 Answers  

How can we use ConnectorJ JDBC Driver with MS SQL?

0 Answers   PUCIT,

What is history table in sql server?

0 Answers  

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,

Explain trigger and its types?

0 Answers  

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

To which devices can a backup be created and where should these devices be located? : sql server management studio

0 Answers  

What is DAC? what is the use of it?

1 Answers   Wipro,

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 Answers  

ehat is the default port no of sql 2000?

2 Answers   IBM,

What happens if you delete a table that is used by a view?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories