You have a relatively new SQL Server 2005 and ms

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

(Continued from previous question...)

You have a relatively new SQL Server 2005 and msdb is corrupt. How can you fix this database without a restore? (data loss is acceptable)

Answer
Stop the server and restart it with a trace flag to allow system databases to be detached. Then copy a new version from the /INSTALL folder.
Explanation
By starting SQL Server with trace flag 3608 you can detach the msdb database. You can copy a new initial version from the installation CD.

(Continued on next question...)

Other Job Interview Questions

• In SQL Server 2005, which network protocols use endpoints?
• What What does the term ACID refer to?
• The TRUSTWORTHY database property is by default?
• What level of permissions does a user need to create an assembly with UNSAFE permissions?
• You are troubleshooting a Service Broker application ...
• What does the CREATE SERVICE statement do in SQL Server 2005?
• What is the recommended way to send mail from SQLAgent in SQL Server 2005?
• To maintain the best performance of your SQL Server 2005 databases, how should you deploy encryption technologies?
• You cannot remember what permissions that the db_accessadmin fixed database role has ...
• In SQL Server 2005, which network protocols use endpoints?
• More...