You are looking to setup a large Notification Se

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

(Continued from previous question...)

You are looking to setup a large Notification Services application...

You are looking to setup a large Notification Services application and you are planning on a 40GB database. When installing Notification Services, the creation fails. What is the likely problem?

Answer
Notification Services installation has a 10 minute timeout and the database creation probably took longer than that.
Explanation
The Notification Services timeout for database creation is 10 minutes. If the database takes longer to create, the installation of the instance fails. You need to reduce the size of the database for installation and then increase it when you are done.

(Continued on next question...)

Other Job Interview Questions

• What is a bookmark lookup?
• In the Windows world, if you hit the "Enter" key on your keyboard between two single quotes and inserted this value, what data would be stored in the column?
• Which key provides the strongest encryption?
• What the heck does ATN2 do?
• What is one of the downsides of using RAID 5 as opposed to RAID 1?
• True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?
• Which of the following is not available to you?
• What could be the problem if you know the service is working properly?
• What can tracer tokens measure in SQL Server 2005 transactional replication?
• Can you call Notification Services APIs from unmanaged code?
• More...