Question 890
An Azure SQL operations team investigates: A scheduled log restore job fails because one backup file is missing from the copy destination. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The acceptance evidence for this incident (A scheduled log restore job fails because one backup file is missing from the copy destination.) is: A controlled restore drill confirms the secondary has received all expected log backups and can be recovered as planned. It directly tests whether the remediation (Use supported SQL Server transaction-log shipping with backup, copy and restore jobs to maintain a warm standby when its recovery characteristics meet objectives.) solves the specified issue, instead of proving an unrelated database control works.
The reported Azure SQL or SQL Server condition is: A scheduled log restore job fails because one backup file is missing from the copy destination. The specific supported administrative response is: Use supported SQL Server transaction-log shipping with backup, copy and restore jobs to maintain a warm standby when its recovery characteristics meet objectives. The technical risk is: A missing copy job or broken log chain can leave the standby many hours behind despite successful primary backups. Confirm the correction with: A controlled restore drill confirms the secondary has received all expected log backups and can be recovered as planned.
Incorrect Answers
Azure SQL database active geo-replication (5.3) addresses another technical failure: An asynchronous geo-secondary may lag behind the primary and individual database failover does not automatically coordinate a multi-database application. The case states: the targeted corrective action AND the evidence that verifies it. The most direct paired action and test is: A controlled restore drill confirms the secondary has received all expected log backups and can be recovered as planned.
Hybrid SQL server dr topology planning (5.1) would demonstrate or implement: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site. This choice can be useful for that problem, but it does not establish the SQL server log shipping for warm standby (5.3) control being assessed here.
Native SQL server full differential and log backups (5.2) addresses another technical failure: An incomplete log chain or wrong recovery model can prevent recovery to the desired point after a failure. The paired-answer requirement concerns SQL server log shipping for warm standby (5.3); this alternative does not provide the matching intervention and separate acceptance evidence.