question

Katie 1 avatar image
Katie 1 asked

Backup log files

Guys,

This is a concept clarification question. Whenever a database is backed up-- it does mean by default that even the log files associated with the database are backed up?

If it not true, what is the process to keep the log files secure and backup on regular basis?

Thanks!

backupadministrationtransaction-log
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image
David Wimbush answered

This is a heavy subject that isn't easily explained in a sentence or two. Luckily there's Paul Randal's blog (http://www.sqlskills.com/blogs/paul/) to explain it. He has also written some excellent articles about the subject in TechNet Magazine which you can read for free: http://technet.microsoft.com/en-us/magazine/default.aspx.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered

No, the log files are not backed up.

You must create a seperate log backup process and schedule.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rob 5 avatar image
Rob 5 answered

The transaction logs are used to recover data in between backups. When you do a full backup, all the logs taken prior to that backup are included in the database. Meaning, the backup contains those transactions. I don't think a backup will backup logs. It resets the checkpoint of the log and the next transaction logs written apply to the current backup.

I hope others can add more information to this question. This is a subject I would like to become more familiar with as well.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.