What is database replicaion? What are the different types
of replication you can set up in SQL Server?
Answer Posted / swapna
Replication is the process of copying/moving data between
databases on the same or different servers. SQL Server
supports the following types of replication scenarios:
Snapshot replication
Transactional replication (with immediate updating
subscribers, with queued updating subscribers)
Merge replication
| Is This Answer Correct ? | 42 Yes | 6 No |
Post New Answer View All Answers
How to replace null values in expressions using isnull()?
If we delete pack Spec what will be the status of pack Body ?
Explain user defined functions?
Explain the truncate command? : SQL Server Architecture
How column data types are determined in a view?
What is sql server transaction log file?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is a DBMS, query, SQL?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What are difference between Cluster index and Non-Cluster index?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
Explain how to send email from sql database?
What is the difference between resultset and resultsetmetadata?
State the difference between local and global temporary tables?
What is clustered index