If you set RETENTION = ON in your SQL Server 200

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

(Continued from previous question...)

If you set RETENTION = ON in your SQL Server 2005 Service Broker queue, what messages are retained?

Answer: Incoming and outgoing messages.

Explanation: Both incoming and outgoing messages are retained in the queue. Outgoing messages are copied to the queue.

(Continued on next question...)

Other Job Interview Questions

• You want to disable the receipt of messages in one of your databases by the Service Broken. How should you do this?
• What is an index? What types of indexes are available in SQL Server 2000?
• Which severity levels of errors can be corrected by a user (as opposed to those that an administrator or Microsoft must work to fix.)
• There are two types of subscriptions in SQL Server replication. What are they?
• You are implementing replication across the Internet for a large bank that wishes to move up to date pricing information...
• You wish to ensure you can recover your SQL Server 2005 database to a point in time if necessary. Which recovery models can you use?
• A .NET assembly running with UNSAFE permissions can do which of the following?
• What is the result of the following query?
• You need to remove a large table from your database ...
• What do you need to do now to ensure you can recover the routes in the event of a disaster?
• More...