Log backups Flashcards Preview

70-464 Certification > Log backups > Flashcards

Flashcards in Log backups Deck (8)
Loading flashcards...
1

Backup LOG Database to Device (No Hint)

Backs up and truncates the log

2

Backup LOG Database to DEVICE WITH NORECOVERY

Backs up tail of the log and leaves the database in a restoring state

3

Backup LOG Database to DEVICE WITH COPY_ONLY

Copies the transaction log but does not truncate it

4

Backup LOG Database to DEVICE WITH NO_TRUNCATE

Backs up the log but does not truncate it.

5

Backs up and truncates the log

Backup LOG Database to Device (No Hint)

6

Backs up tail of the log and leaves the database in a restoring state

Backup LOG Database to DEVICE WITH NORECOVERY

7

Copies the transaction log but does not truncate it

Backup LOG Database to DEVICE WITH COPY_ONLY

8

Backs up the log but does not truncate it.

Backup LOG Database to DEVICE WITH NO_TRUNCATE