What is database replicaion? What are the differ

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is database replicaion? What are the different types of replication you can set up in SQL Server?

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
See SQL Server books online for indepth coverage on replication. Be prepared to explain how different replication agents function, what are the main system tables used in replication etc.

(Continued on next question...)

Other Job Interview Questions

• What is a major difference between SQL Server 6.5 and 7.0 platform wise?
• How many bits IP Address consist of?
• What is a major difference between SQL Server 6.5 and 7.0 platform wise?
• What are the steps you will take, if you are tasked with securing an SQL Server?
• Define candidate key, alternate key, composite key.
• What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
• Explain CREATE DATABASE syntax
• What is database replicaion? What are the different types of replication you can set up in SQL Server?
• Can you have a nested transaction?
• What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
• More...