More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
How do you recover the snapshot?
You have created a database snapshot on SQL Server 2005 for the sales database to capture the end-of-month activity. The next day your server fails and you need to recover to a standby server using the previous night's backups. How do you recover the snapshot?
Answer
There is nothing you can do. The snapshot is lost.
Explanation
Database snapshots cannot be backed up, so once the server failed, the database snapshot was lost.
(Continued on next question...)