What is database replicaion? What are the different types
of replication you can set up in SQL Server?
- 1 Answers
- 4363 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 dbcc? : sql server DBA
How to start SQL Server in minimal configuration mode?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
How would you go about verifying the network name that the local_listener is currently using?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you find out if a table can be redefined?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What would you do with an "in-doubt" distributed transaction?
Query processing is slow(eg select query)how will u solve that
What is replication? : sql server DBA
Why would you call update statistics? : sql server DBA
What is the importance of a recovery model? : sql server DBA
