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 are the different types of normalization?
Can I disable or restrict ssrs export formats (rendering formats)?
Why the trigger fires multiple times in single login?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is the difference between char, varchar and nvarchar?
Do you know clustered and non-clustered index?
between cast and convert which function would you prefer and why?
Can we install sql server 2016 on windows 7?
What is table join?
What is single-user mode?
What is the contrast between sql and pl/sql?
Working with TLogs
What is the maximum size of column in sql server?
Do you know what are acid properties of transaction?
What is the index requirement in SQL Azure?