You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to the least. So what action should you perform to achieve this goal? ()
- A、You should restore the full backup
- B、You should restore the database snapshot from 16:30 hours.
- C、You should restore the database snapshot from 17:30 hours
- D、You should restore both the full backup and the differential backup.
正确答案:D
答案解析:有
微信扫一扫手机做题