What is database replicaion? What are the different types
of replication you can set up in SQL Server?
- 1 Answers
- 4404 Views
- I also Faced
- E-Mail Answers
Answer Posted / kishor
move/copy of the data from one server to another server is
call replication
types of replication
1.snapshot
2.merge
3.transactional
4.transactional with up-datable subscription(newly added in
sql server2005)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between clustered and non-clustered index? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
How do you open a cluster administrator? : sql server DBA
when does an alert gets signaled?
how can you connect from 10g user to 11g user??
how does an oracle clusterware manage crs resources?
What is transparent data encryption? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How would you extract DDL of a table without using a GUI tool?
How to start SQL Server in minimal configuration mode?
what is logical system in sap basis
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is the importance of a recovery model? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Which autogrowth database setting is good? : sql server DBA
