what is the diffrence between Snap Shot and Transaction
Replication
Answer Posted / 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 |
Post New Answer View All Answers
What is meant by datasource?
How do I find the sql server database version?
What is the exact numeric data type in sql?
what is raid? : Sql server database administration
Tell me can we use custom code in ssrs?
Explain error handling in ssis?
Can we return Data from 4(more than 1) tables in stored procedure?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Is foreign key unique?
what are the core components of SSRS?
What is a system database and what is a user database?
What is triggers in ms sql server?
What is the difference between osql and query analyzer?
What are the differences between decimal and float in ms sql server?
What are the differences between triggers and stored procedures?