Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday, which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario?()
- A、 recovery cannot be performed because a backup was not performed after the last incomplete recovery
- B、 restore all the files from Sunday’s backup, and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
- C、 restore all the files from Sunday’s backup, and open the database to reset the database to the point in time when the backup was performed on Sunday
- D、 restore all the files from Sunday’s backup, and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
正确答案:D
答案解析:有
微信扫一扫手机做题