🔥 3-day streak
Microsoft Azure Database Administrator Associate38 / 144
Question 38 of 144

You manage a 2 TB database on a SQL Server 2022 instance running on an Azure VM. The database uses the FULL recovery model. A full backup is taken every Sunday at 01:00, and transaction log backups run every 15 minutes. Restoring 6 days of transaction log backups after a failure late in the week takes several hours, exceeding the agreed RTO. You must reduce restore time without increasing the full backup frequency. What should you add to the backup strategy?

Reviewed for accuracy · Report an issueNext question