DBA > Job Interview Questions > Microsoft SQL Server FAQs

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