These sorts of issues with Agent Jobs are almost always down to the account context that the job is run under, or problems with impersonation. See:

Implementing SQL Server Agent...

As the question is written (and as is usual for this sort of requirement) only a LEFT (or RIGHT) OUTER JOIN is required.

SQL Server 2008 also contains some advanced optimisations...

Because SQL Server will not run without one 🙂

The transaction log records absolutely every change made to a...

Gary7512 (5/28/2010)

---

The backup uses VSS which takes a shadow copy of the drives and works around the issue of locked files. However, I have not actually tested restoring a sql...

Yes definitely worth testing.

Moving...

Indianrock (5/28/2010)

---

Did I understand correctly that if you went to bulk logged ( or simple?) before reindexing, you could then resume full recovery and log backups afterwards without doing...

Stefan Krzywicki (5/28/2010)

---

Heh, I'd love to see...

Kevin Landry (5/28/2010)

---

I have also considered the Bulk-Logged option, but I do not see how switching to Simple is any more dangerous than using the Bulk-Logged option?

Switching to any other...

James_DBA (3/17/2010)

---

To start off with an improperly sized log file such as that of which you are describing can actually hurt your performance in a magnitude that is unacceptable. You...

My personal view on all this is that transaction log auto-growths are there only as a last resort.

It makes sense to me to over-size the transaction log initially (while being...

James,

There are a few things from the article I'd like to comment on directly:

How about the times you need to grow your log? I did a recent search and had...

Kevin Landry (3/29/2010)

---

Most of the issues that I see on Transaction Log File growth are due to the recording of index rebuilds. Meaning, with the FULL recovery model, whenever there...

Alberto De Rossi-378909 (7/16/2009)

---

I'm Triyng to autogrowth a log file. A created a DB witn one table with a couple of char 8000 fields, inserted many, many rows. But the...

Good enough explanation for me. Funny about the confusion over Dave's signature.

I retract the 'lazy' comment, partially. Clearly Maddy made a lot of effort was made to solve...

Arto,

I do vaguely remember something like this being a bug - I'll see if I can track the Connect item down.

In any case, it seems fixed in the latest 2005...