Somebody with permissions is turning it off. Or there is a scheduled job doing it. It is possible that a startup proc is also disabling it explicitly. ...

If I understand correctly, you saw one level of fragmentation, ran the rebuild and think that the fragmentation is the same?

You have less than 1% fragmentation in the logical and...

Stefan Krzywicki (12/29/2011)

---

I can't even get them to buy...

GilaMonster (12/29/2011)

---

Grant Fritchey (12/29/2011)

---

GilaMonster (12/29/2011)

---

Grant Fritchey (12/27/2011)

---

Based on the fact that we can't get people to run good sets of backups despite Umptymillion articles, blog posts, presentations, webcasts and screaming...

Stefan Krzywicki (12/29/2011)

---

GSquared (12/29/2011)

---

Dev (12/29/2011)

---

I thought some "Magic" (recovery trick) will happen & that DB will be saved. It’s a nice learning opportunity that I missed. However the...

Brandie Tarvin (12/29/2011)

---

GilaMonster (12/29/2011)

---

Grant Fritchey (12/27/2011)

---

Based on the fact that we can't get people to run good sets of backups despite Umptymillion articles, blog posts, presentations, webcasts and screaming lightning...

GilaMonster (12/29/2011)

---

Grant Fritchey (12/27/2011)

---

Based on the fact that we can't get people to run good sets of backups despite Umptymillion articles, blog posts, presentations, webcasts and screaming lightning talks, I...

Revolution

This will help you find the cause of the growth in tempdb.

http://www.sqlservercentral.com/articles/Log+growth/69476/

SQL Kiwi (12/28/2011)

---

True - but this was a change (in 2005) so for many people the change in behaviour...

2011 was great and here's to an even better 2012.

Use the query here to find your failed jobs.

http://sqlserverpedia.com/wiki/SQL_Server_Agent_Job_Query_Samples

To query backups for a database, you can query the backupset (and backup tables) in the msdb database.

Can you post execution plans for each of the two methods?

Take a look at this article.

http://msdn.microsoft.com/en-us/library/ms191250.aspx

Badda bing - log backups. People should know this one.