If you aren't overly worried about recovery, then switch to simple, and delete in batches, which will limit log file size. Then switch back to full, make a full backup,...

You can do that, but make a full backup after getting back to full so you can keep your recovery chain intact.

You can batch delete, and run log backups as...

Bruce,

My apologies if it seemed that I was complaining. I thought you had a nice script there and a great start. I wanted the OP to think it through a...

Jim Murphy (11/28/2011)

---

It's been about 15 or 20 years since I last went snow skiing. Maybe I'll have the chance in January if my session gets picked up. Never...

A couple notes.

First, I might actually try to do this more intelligently and read the current db size and then set some percentage. 10% of 10MB makes sense. 10% of...

Thanks, we had a great time, great weather. Not a ton of snow, but...

The state of tracing shared users isn't great.

On the client side, I wasn't thinking of an altering code but more something like a "@debug=1" passed into procs as an additional...

Ray K (11/22/2011)

---

I think it makes sense. Can you name another professional league that has 16 teams in one league and 14 in...

Saw this last week on vacation. Glad to see it and glad that no bias prevented it. He...

The thing I've seen some people do is add extra logging to client code that can be enabled when there's an issue. This can trigger something to allow you to...

I'm baaaaaackkkkk

Immunity granted to all problems in the Thread over the last week. No way I'm going through the last week of posts.

My apologies. I have corrected the explanation to note the string comparison.

Thanks, and glad you enjoyed it.

And not switching back to Big Ben likely makes me a poor spoiler 😛

Revenant (11/22/2011)

---

Just squeeze them in a vise. It si clean and gets the job done.

Most people do not realize that there are hard drives in copiers, and that your...