Câu 66: 70-462: MCSA Administering Microsoft SQL Server 20122014 Databases

You administer a Microsoft SQL Server 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 read-only state that can also have further transaction logs applied. Which option of the BACKUP LOG command should you use?

1. A. FORMAT
2. B. NO_TRUNCATE
3. C. STANDBY — đáp án hiện tại
4. D. NORECOVERY