How do you recover the snapshot?

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...)

Other Job Interview Questions

• You want to disable the receipt of messages in one of your databases by the Service Broken. How should you do this?
• Which framework would you use to manage this database programatically?
• Which key does the OPEN MASTER KEY statement open?
• When you use the sp_xml_preparedocument stored procedure in SQL Server 2000, what is returned?
• If you absolutely need a report to look the same regardless of what OS or viewing software is being used, which of the following file formats would be the best choice?
• In SQL Server 2005, which network protocols use endpoints?
• In SQL Server 2005, you want to monitor your transactional replication and determine how long it takes for a transaction to move from the publisher to a subscriber. What would you use to help you do this?
• Which optional SQL Server component must you install to ensure that you can create and execute maintenance plans?
• Which of the following is an invalid file name for a database file?
• What does the CREATE SERVICE statement do in SQL Server 2005?
• More...