Câu 4: 70-765: Provisioning SQL Databases
You have a database named DB1 that uses simple recovery mode. Full backups of DB1 are taken daily and DB1 is checked for corruption before each backup. There was no corruption when the last backup was complete. You run the sys.columns catalog view and discover corrupt pages. You need to recover the database. The solut…
Nội dung câu hỏi
You have a database named DB1 that uses simple recovery mode. Full backups of DB1 are taken daily and DB1 is checked for corruption before each backup. There was no corruption when the last backup was complete. You run the sys.columns catalog view and discover corrupt pages. You need to recover the database. The solution must minimize data loss. What should you do?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. Run RESTORE DATABASE WITH RECOVERY.
- B. Run RESTORE DATABASE WITH PAGE. — đáp án hiện tại
- C. Run DBCC CHECKDB and specify the REPAIR_ALLOW_DATA_LOSS parameter.
- D. Run DBCC CHECKDB and specify the REPAIT_REBUILD parameter.
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.