You administer a Microsoft SQL Server 2012 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
B
B
RESTORE WITH NORECOVERY
Leaves the database in the restoring state. This allows you to restore additional backups in the current recovery path.
https://msdn.microsoft.com/en-us/library/ms188223.aspx
RESTORE WITH NORECOVERY IS for Restore commend, not for BACKUP LOG Commend.
B
https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql
NORECOVERY
Backs up the tail of the log and leaves the database in the RESTORING state. NORECOVERY is useful when failing over to a secondary database or when saving the tail of the log before a RESTORE operation.
To perform a best-effort log backup that skips log truncation and then take the database into the RESTORING state atomically, use the NO_TRUNCATE and NORECOVERY options together.