You are the administrator of a SQL Server 2008 instance with a database named DB1. DB1 has two filegroups: one is a filegroup named History that contains historical data stored in the G: volume; the…

You are the administrator of a SQL Server 2008 instance with a database named DB1. DB1 has two filegroups: one is a filegroup named History that contains historical data stored in the G: volume; the other is the PRIMARY filegroup that contains the On-Line Transaction Processing (OLTP) data stored in the F: volume. The backup strategy of DB1 has three requirements:

• first, the History filegroup should be backed up at the end of each

working day;

• second, the PRIMARY filegroup should be backed up five times a day;
• third, the transaction log should be backed up every quarter.

You get a report at 13:00 saying that the volume which contains the History filegroup fails. As the technical support, you have to restore the database, and you must reduce the data loss to the least as soon as possible. What should you do?