Log backups Flashcards
Backup LOG Database to Device (No Hint)
Backs up and truncates the log
Backup LOG Database to DEVICE WITH NORECOVERY
Backs up tail of the log and leaves the database in a restoring state
Backup LOG Database to DEVICE WITH COPY_ONLY
Copies the transaction log but does not truncate it
Backup LOG Database to DEVICE WITH NO_TRUNCATE
Backs up the log but does not truncate it.
Backs up and truncates the log
Backup LOG Database to Device (No Hint)
Backs up tail of the log and leaves the database in a restoring state
Backup LOG Database to DEVICE WITH NORECOVERY
Copies the transaction log but does not truncate it
Backup LOG Database to DEVICE WITH COPY_ONLY
Backs up the log but does not truncate it.
Backup LOG Database to DEVICE WITH NO_TRUNCATE