What does the Log Reader agent in SQL Server 200

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

(Continued from previous question...)

What does the Log Reader agent in SQL Server 2005 replication do?

Answer
This agent reads the publisher log for transactions to send to the distributor.

Explanation
This agent is tasked with reading the transaction log in transactional replication and moving those transactions that need to be replicated to the distributor.

(Continued on next question...)

Other Job Interview Questions

• What does SEND do in SQL Server 2005?
• You have just upgraded your server from a single processor by adding 3 additional processors....
• What is one of the downsides of using RAID 5 as opposed to RAID 1?
• A certificate is which type of security mechanism?
• You want to disable the receipt of messages in one of your databases by the Service Broken. How should you do this?
• Yesterday's QOD How are comments denoted in an XML document?
• What is the timestamp datatype used for?
• In SQL Server 2005, what does instance aware mean for a service?
• Which of the following is not available to you?
• What does HAS_DBACCESS() do?
• More...