Note: This question is part of a ser

ies of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply

only to that question.

A company has several Microsoft SQL Server database in Microsoft Azure.

One database experiences a storage failure, and pages that store critical database metadata are corrupted.

You need to perform an offline restore of the da

tabase-s pages.

Which option should you use first?

A. backup compression

B. backup encryption

C. file snapshot backup

D. mirrored backup media sets

E. SQL Server backup to URL

F. SQL Server Managed Backup to Azure

G. tail-log backup

H. back up and tru

ncate the transaction log

An unbroken chain of log backups must be available, up to the current log file, and they must all be applied to bring the page up to date with the current log file.

A tail-log backup captures any log records that have

not yet been backed up (the tail of the log) to prevent work loss and to keep the log chain intact. Before you can recover a SQL Server database to its latest point in time, you must back up the tail of its transaction log. The tail-log backup will be the

last backup of interest in the recovery plan for the database.

Note: The goal of a page restore is to restore one or more damaged pages without restoring the whole database. Typically, pages that are candidates for restore have been marked as -suspect- be

cause of an error that is encountered when accessing the page.

References:

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/tail-log-backups-sql-server?view=sql-server-2017#TailLogScenarios

https://docs.microsoft.com/en-us/sql/rel

ational-databases/backup-restore/restore-pages-sql-server?view=sql-server-2017#Restrictions