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
Explain the truncate command?
What is a raid and what are different types of raid configurations?
How to run sql server 2005 books online on your local system?
What are data regions?
How to create hyperlink from returned sql query ?
What are the types of sql server?
How to create an index on a view?
What are trace flags?
What is the use of nvl work?
What is the query and subquery?
Explain contrast amongst grouped and non-bunched records?
How to list all stored procedures in the current database using ms sql server?
In what three ways is the return statement used in a stored procedure?
Which is better statement or preparedstatement?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?