What is database replicaion? What are the different types
of replication you can set up in SQL Server?
- 1 Answers
- 3821 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 role of dip user in our database?
How do you open a cluster administrator? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain materialized views and how they are used.
What purpose does the model database server? : sql server DBA
how does an oracle clusterware manage crs resources?
What happens on checkpoint? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what are the types of connection load-balancing?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How to start SQL Server in minimal configuration mode?
What are the commands used in dcl? : sql server DBA
