How To Take Tail Log Backup

How To Take Tail Log Backup

Tail log backup is like any log backup, a tail-log backup is taken by using the statement BACKUP LOG. You can take a tail-log backup in the following situations: 

If the database is online:

before starting a restore sequence, back up the tail of the log using WITH NORECOVERY whenever the next action you plan to perform on the database is a restore operation:  

BACKUP LOG database_name TO WITH NORECOVERY

(To avoid an error, the NORECOVERY option is necessary) 

If the database is offline and does not start:
Try to take a tail-log backup. Because no transactions can occur at this time, using WITH NORECOVERY is optional. If the database is damaged, use either WITH CONTINUE_AFTER_ERROR or WITH NO_TRUNCATE. 

BACKUP LOG database_name TO [WITH { CONTINUE_AFTER_ERROR | NO_TRUNCATE } 

We recommend that you avoid using NO_TRUNCATE, except when the database is damaged. If the database is damaged, for example, if the database does not start, a tail-log backup succeeds only if the log files are undamaged, the database is in a state that supports tail-log backups, and the database does not contain any bulk-logged changes.

how to take tail log b