You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing the use of a NORECOVERY backup strategy.
Which of the following is TRUE with regards to this strategy? (Choose all that apply.)

A.
It backs up the tail of the log and leaves the database in the RESTORING state.

B.
It does not affect your overall backup and restore procedures for the database.

C.
It is useful when failing over to a secondary database

D.
It Backs up the tail of the log and leaves the database in the read-only state.

Explanation: