I like to see questions like this cycled through from time to time.:w00t:

Burden

Something that has worked very well for me in this case is to run two tlog backups back to back. That will often times clear that transaction.

Very good. Thanks for posting an update with an answer to your own question. 😉

I like the article and the concepts you have laid out for us.

Thanks

Tara-1044200 (7/11/2012)

---

i have more than 400 dbs so i cant use spmsforeachdb as it wonts display everything in the result, is there a way i can just get the list...

Michael Lysons (7/11/2012)

---

Sadly, I think part of the problem is another human trait; the ridicule of those who are wrong.

It's even evident on this site. Just look at a whole...

Jack Corbett (7/10/2012)

---

I agree with Grant.

The only issue with Extended Events on 2008 is that there are some key events that aren't available in Extended Events...

Query sys.database_principals in each database for that user.

steak and maggots

GilaMonster (7/11/2012)

---

I said some students, not referring to self.

Lots of deadlines...

It's possible that AV is running against the C as well and not the E.

I would check antivirus exclusions and settings.

As for the "backup crawler" - monitor task manager for...

Speaking of which, do you want some of my work and deadlines?

I think it is an expected behavior from this undocumented procedure.

Lynn Pettis (7/11/2012)

---

That's okay, but the links don't seem to work where I am. ...