Administering a SQL Database Infrastructure — Question 93

You administer a Microsoft SQL Server 2016 database.
The database is currently configured to log ship to a secondary server.
You are preparing to cut over to the secondary server by stopping log-shipping and bringing the secondary database online.
You want to perform a tail-log backup. You need to leave the primary database in a restoring state.
Which option of the BACKUP LOG command should you use?

Answer options

• A. NO_TRUNCATE
• B. NORECOVERY
• C. STANDBY
• D. FORMAT

Correct answer: B

Explanation

The correct option is B, NORECOVERY, because it allows the backup to be taken while keeping the primary database in a restoring state, which is necessary for log shipping scenarios. The other options either complete the backup process (A, C) or format the media (D), which is not suitable for this situation.