DBA > Job Interview Questions > Microsoft SQL Server FAQs

To recover an instance of Notification Services

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

(Continued from previous question...)

To recover an instance of Notification Services in 2005 on another server, what information would you need?

Answer
A backup of the database holding Notification Services and the XSD and XSLT files as well as the name and password for the service account.
Explanation
To recover SSNS, you need the database backup as well as the operational files, XSD and XSLT files, stored on the file system and the account information used for the service account. Since SSNS usually works with data outside of the SQL Server, a domain account is usually used to ensure proper permissions.

(Continued on next question...)

Other Job Interview Questions