Sql server 2008 backup - backup tail of the log

Question

Setting up maintenance plan for sql server 2008 backup

Don't understand what exactly backup tail of the log, i read some ms articles about this. Still dumb enough for database to figure out what need to do.

For regular backup strategy do i need to select backup tail of the log option? What would i loose or get with this option?

If i select it what i need to know for restore.

Answer 1

No, backup tail is a disaster recovery option. You do them just before attempting to do a restore, after a disaster: you attempt to backup the log tail, if possible, in hope that all data can be recovered.

For regular maitenance jobs, you do a normal log backup. See Tail-Log Backups.