Close.

A log consists internally of lots of VLFs (virtual log files). When a log backup occurs all VLFs that do not contain active portions of the log (portions still possibly...

If you set the DB to simple you break the log chain. That may not sound important with a full backup straight after, but what if that full backup's not...

WayneS (6/23/2009)

---

David O (4/9/2008)

---

Most of them are pretty good but you got two I'm thinking could be a problem.

If you've go the maintenance window. I'd run dbcc dbreindex...

You watch the database for a few weeks and see how big it grows. If it's too big (in your opinion) make your log backups more frequent, do a once-off...

A bookmark lookup is done when SQL uses an index for a query but that index is not covering. Hence SQL has to lookup to the cluster/heap (bookmark lookup) to...

Set the log to a size that it needs to be for the volume of transactions and frequency of log backups and then leave it alone. Repeated shrink/grow can cause...

Lynn Pettis (6/23/2009)

---

I've had it suggest that I include over half of the columns from the table and that just doesn't make sense to me as that would make the...

Correct, the...

If you're talking about the default instance, then it's 'name' is the server's name. With named instances you can specify the instance name, but the base is still the server's...

Specifically....

Deprecated in SQL 2005, gone in SQL 2008.

Oh, and the full backup goes after the log truncation. If you do it before then the log...

HDMan (6/23/2009)

---

Thanks, Gail. I read through it, and I understand what the log is and how it's used. But that failed to answer my question. Basically, of...

Why don't you tell us what errors and what lines, and we'll advice you on resolving them.

Personally,...

Please read through this - Managing Transaction Logs[/url]

nscott (6/23/2009)

---

Thanks for your help! The field in question contains a value of "LOG_BACKUP". As mentioned above, I have performed full backups of the transaction log, with no...