In which order do you perform an upgrade to SQL

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

(Continued from previous question...)

In which order do you perform an upgrade to SQL Server 2005 for replicated databases?

Answer
Distributor, Publisher, then Subscriber.

Explanation
You always perform an upgrade in this order: distributor, publisher, subscriber.

(Continued on next question...)

Other Job Interview Questions

• You want to be sure that your reporting solutions using a database snapshot are properly protected from disaster. How can you back up your database snapshots?
• What the heck does ATN2 do?
• What is one of the downsides of using RAID 5 as opposed to RAID 1?
• What is a zettabyte?
• How do you recover the snapshot?
• If you set RETENTION = ON in your SQL Server 2005 Service Broker queue, what messages are retained?
• You are performing a number of SELECT queries on one of your SQL Server 2005 Service Broker queues and you get a call that applications using the queues are running slowly. What can you do?
• Can you give me an overview of some of the database objects available for use in SQL Server 2000?
• What does a report model provide in SQL Server 2005 Reporting Services?
• What is the easiest way to capture the SQL statement for a Report Builder report you're troubleshooting?
• More...