In SQL Server 2005, what does instance aware mea

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

(Continued from previous question...)

In SQL Server 2005, what does instance aware mean for a service?

Answer
The service is installed once for each instances on the server.

Explanation
An instance aware service is one that is installed for each instance on the server. An instance-unaware service is only installed once , no matter how many instances. Integration Services is instance-unaware whereas SQL Agent is instance aware.

(Continued on next question...)

Other Job Interview Questions

• How do you recover the snapshot?
• If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
• What could be the problem if you know the service is working properly?
• What tool is available for ad hoc reporting by non IT end users in Reporting Services 2005?
• You are writing a new stored procedure to perform maintenance on your SQL Server 2005 databases that defragments the indexes in an online manner. What command should you use?
• What is a dialog conversation in the SQL Server 2005 Service Broker.
• You cannot remember what permissions that the db_accessadmin fixed database role has ...
• What does the DUMP command do?
• You want to be sure that your Scalable Shared Database is as available as possible. Which of the following is not needed for this?
• What does the DEALLOCATE statement do in SQL Server 2005?
• More...