You want to be sure that your reporting solution

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

(Continued from previous question...)

You want to be sure that your reporting solutions using a database snapshot are properly protected from disaster. How can you back up your database snapshots?

Answer
You cannot back up a database snapshot.
Explanation
A database snapshot cannot be backed up or restored.

(Continued on next question...)

Other Job Interview Questions

• You want to script the execution of an Integration Services package from the command line for use from a Unix scheduler. What utility would you use?
• After you've completed a backup for your Sales server to disk...
• Which utility is used to administer SQL Server 2005 Notification Services instances?
• In SQL Server 2005, can you include a user-defined role as a member of another user-defined role?
• Which protocols support Kerberos authentication on SQL Server 2005?
• If you want to apply a hot fix to SQL Server 2005, do you need to apply them all in order?
• You have a SQL Server 2005 cluster and need to add anti-virus software as per your corporate standards. What should you exclude from scans?
• What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?
• How can you determine which user is executing statements in Profiler?
• In SQL Server 2005, if you want the keys securing your data to expire over time, what type of key encryption would you choose?
• More...