Interested to Buy Any Domain ? << Click Here >> for more details...
What is database replicaion? What are the different types
of replication you can set up in SQL Server?
- 1 Answers
- 4797 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 dropping a database and taking a database offline? : sql server DBA
What is transparent data encryption? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What authentication modes does sql server support? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you schedule a job in database?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
when does an alert gets signaled?
How can you control the amount of free space in your index pages? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
Why would you call update statistics? : sql server DBA
what is the use of ocr?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
