Valid 70-765 Dumps shared by ExamDiscuss.com for Helping Passing 70-765 Exam! ExamDiscuss.com now offer the newest 70-765 exam dumps, the ExamDiscuss.com 70-765 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-765 dumps with Test Engine here:
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?
Correct Answer: B
A page restore is intended for repairing isolated damaged pages. Restoring and recovering a few individual pages might be faster than a file restore, reducing the amount of data that is offline during a restore operation. RESTORE DATABASE WITH PAGE Restores individual pages. Page restore is available only under the full and bulk-logged recovery models. References: https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements- transact-sql
Recent Comments (The most recent comments are at the top.)
maria - Sep 19, 2018
Page restore applies to SQL Server databases that are using the full or bulk-logged recovery models. Page restore is supported only for read/write filegroups. DBCC CHECKDB can repair corruption if you specify the REPAIR_ALLOW_DATA_LOSS option answer is C
Recent Comments (The most recent comments are at the top.)
Page restore applies to SQL Server databases that are using the full or bulk-logged recovery models. Page restore is supported only for read/write filegroups.
DBCC CHECKDB can repair corruption if you specify the REPAIR_ALLOW_DATA_LOSS option
answer is C