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
How can you stop stored procedures from recompiling?
What is SQL Azure Fabric?
How to transfer an existing table from one schema to another schema in ms sql server?
What is failover clustering overview?
What happens when unicode strings concatenate with non-unicode strings?
What is the difference between for auto and for nested?
What is the default server name for sql server?
What is the chart in report?
What is store procedure? How do they work?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
Explain how would you store your query in an SSRS report or a Database server?
Explain system scalar functions?
List some major differences between triggers and stored procedures?
How to enter comments in transact-sql statements?
Explain microsoft sql server functions?