It is my thinking that you have to run the BEGIN TRANSACTION ... WITH MARK against all the DB's in the set - So assume it has to be done...

Thanks Wayne - I think that will do it!

Awesome ideas!

Thanks!

Perfect!

Thanks!

Wally

Sorry,

varchar(50)

BEACHDBA (2/22/2008)

---

If you are managing 2000 & 2005 and don't see 2008 in your near future, there could still be an argument for pursuing the 2005 track as it could...

Jeff,

If you haven't undertaken any exams as of yet, I would wait.

I have my MCDBA, and was about to take the two exams to upgrade, but decided to wait until...

Yup, probably can't do that though... There are only a few on the table and they are highly utilized...

Thanks All!

Thanks gang, you've got me off to a great start!

The table currently has 5 years of data in it. We want it to only have 60 days of history moving forward.

So I need to delete about 40 million rows,...

Ditto... I only shrink a logfile if I've had some type of a unique event (like a large DW insertion etc.) that causes it to grow to nonstandard size.

Why don't...

Very strange.

If you can truncate it manually then SQL Server already knws that there are no open or uncommited transactions... So Checkpoint SHOULD be cleaning up!

Perfect!

Actually had just about figured it out.

Thanks Mark.