🔥 3-day streak
Microsoft Azure Database Administrator Associate31 / 144
Question 31 of 144

You manage a SQL Server 2022 instance hosting a production database that uses the FULL recovery model. A nightly full backup and 15-minute transaction log backups are scheduled through a well-established maintenance plan, and these backups form the basis of your point-in-time restore strategy. A developer asks you to take an ad hoc full backup right now so they can refresh a test environment. You must ensure this manual backup does NOT interfere with the existing restore chain used for disaster recovery. Which backup approach should you use?

Reviewed for accuracy · Report an issueNext question