Which option of the BACKUP LOG command should you use?

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?

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

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

FO

FO

Correct answer is A
when you want to take a tail log backup GUI way , on option page you need
to uncheck ‘Truncate the Transaction log’ and Check the ‘Backup the tail of the log and leave the database in the restoring state’, also if you Script out the command you will see the ‘WITH NO_TRUNCATE’ clause in the script, but not ‘with norecovery’ clause .
Correct me please if I’m wrong.

Reply