You administer a Microsoft SQL Server 2012 database. The database is curr

ently 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 i

n a restoring state.

Which option of the BACKUP LOG command should you use?

A. NO_TRUNCATE

B. NORECOVERY

C. STANDBY

D. FORMAT