what is the diffrence between Snap Shot and Transaction Replication

what is the diffrence between Snap Shot and Transaction
Replication

Question Posted / bhaskar

2 Answers
12162 Views
CSC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers Perot Systems,

Why de-normalization required?

0 Answers

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers

How do I change my passwords (database, LDAP, and so on) without causing an outage?

0 Answers IBM,

What is a bit datatype?

0 Answers

Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?