x

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!

more ▼

asked May 07, 2010 at 12:19 PM in Default

avatar image

Katie 1
1.4k 132 164 205

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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.

more ▼

answered May 07, 2010 at 12:52 PM

avatar image

David Wimbush
10.7k 30 34 43

(comments are locked)
10|1200 characters needed characters left

No, the log files are not backed up.

You must create a seperate log backup process and schedule.

more ▼

answered May 07, 2010 at 12:26 PM

avatar image

Grant Fritchey ♦♦
137k 20 44 81

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered May 07, 2010 at 12:31 PM

avatar image

Rob 5
12 1 1 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x247
x133
x94

asked: May 07, 2010 at 12:19 PM

Seen: 1150 times

Last Updated: May 07, 2010 at 12:19 PM

Copyright 2017 Redgate Software. Privacy Policy