Which option of the BACKUP LOG command should you use?

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?
A . NO_TRUNCATE
B . NORECOVERY
C . STANDBY
D . FORMAT

Answer: B

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments