CODEWITHSUNDEEP
sql-server
mamu
mamu

Reputation: 12414

Sql server 2008 backup - backup tail of the log

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.

Upvotes: 0

Views: 1365

Answers (1)

Remus Rusanu
Remus Rusanu

Reputation: 294267

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.

Upvotes: 2

Related Questions