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
What is the difference between commit and rollback?
What is 5nf in normalization form?
Which sql server table is used to hold the stored procedure scripts?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Are semicolons required at the end of sql statements in sql server 2005?
What do you understand by a view?
What is triggers in ms sql server?
What do you need to connect php to sql server?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Name few of the dcl commands in sql?
Can a table have 2 primary keys?
What is enhanced database mirroring in sql server 2008?
Explain what are the events recorded in a transaction log?
How fixed length strings are truncated and padded?
Who is the owner of a schema in ms sql server?