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?
asked May 07, 2010 at 12:19 PM in Default
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.
answered May 07, 2010 at 12:52 PM
No, the log files are not backed up.
You must create a seperate log backup process and schedule.
answered May 07, 2010 at 12:26 PM
Grant Fritchey ♦♦
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.
answered May 07, 2010 at 12:31 PM