Log backups Flashcards

1
Q

Backup LOG Database to Device (No Hint)

A

Backs up and truncates the log

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Backup LOG Database to DEVICE WITH NORECOVERY

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Backup LOG Database to DEVICE WITH COPY_ONLY

A

Copies the transaction log but does not truncate it

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Backup LOG Database to DEVICE WITH NO_TRUNCATE

A

Backs up the log but does not truncate it.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Backs up and truncates the log

A

Backup LOG Database to Device (No Hint)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

Backup LOG Database to DEVICE WITH NORECOVERY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Copies the transaction log but does not truncate it

A

Backup LOG Database to DEVICE WITH COPY_ONLY

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Backs up the log but does not truncate it.

A

Backup LOG Database to DEVICE WITH NO_TRUNCATE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly