YOU HAVE BEEN ASKED TO CREATE A BACKUP OF YOUR PRODUCTION DATABASE...

3. You have been asked to create a backup of your production database and restore it on a development server. Your production server is using the full recovery model. Full backups are taken Monday and Wednesday. Transaction log backups are taken every hour. Today is Friday. The backup needs to be created as quickly as possible. What’s the fastest way to get the latest database copy while minimizing impact to production?A. Create a normal backup. Use that to restore to development.B. Create a Copy Only Backup. Use that to restore to development.C. Use the Wednesday backup. Restore the transaction log backups since Wednesday.D. Copy the .mdf and log files and use SP_attach.