1. What is the mandatory restore command that you need to use if you have further restores or backup files that you need to apply before recovering the database for use?

2. If you want to have a simple recovery model for any newly created databases in a given instance by default, which system database recovery model has to be changed into simple recovery?

3. Write the steps to recover a production database if the database crashed on Wednesday at 11:55 A.M. with a database having a full backup every Sunday at 6:00 P.M., differential backup everyday at 6:00 P.M. except Sunday and hourly transaction log backup everyday.

Answer rating: 100% (QA)

1 The mandatory restore command you need to use if you have further restores or backup files that yo... View the full answer