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 LOG backup strategy.
Which of the following is TRUE with regards to this strategy? (Choose all that apply.)
A.
You have to create a full backup prior to creating the initial log backup.
B.
The initial log backup can be created regardless of whether a full backup has been created.
C.
The entire log is backed up every time the backup executes.
D.
The log is backed up from the last successfully performed log backup to the end of the latest
log.
Explanation: