Thanks, I missed those!

Jason

Or I could have searched on Google for "sql server create corrupt database" in which case the top two results would be an article by Perry Whittle (How To Create...

Well, despite the lack of production from the Tigers' bats, it was a fun series.

Congrats to the SF Giants, World Series Champs 2012!

(maybe I should've specified the Tigers as the...

I'm reminded of a quote from the movie "Red Heat:[/url]"

"Ivan Danko: I do not understand this sport.

Art Ridzik: You're not supposed to, it's completely American.

Ivan Danko: We play...

While you can install both (I've got SQL2012 Enterprise and SQL2008R2 Express on my work PC,) one of them will have to be a named instance.

IE if you install SQL2008R2...

Lowell,

I actually just stole your code, pretty much word for word. Below is the Agent Job step 1 I'm using:

use msdb

go

declare @DeleteToDate datetime()

set @DeleteToDate = DATEADD(d, -30, getdate())

DELETE FROM...

Steve Jones - SSC Editor (10/22/2012)

---

I know I like cherry or blueberry, and I know that I don't like the creamy/chocolatey pies. I don't know if there are other pies...

My thanks to Lowell!

Using your Delete commands, plus adding one to delete from dbo.sysmail_mailitems, the DB is down to about 23GB from 133GB!

Set up an Agent job to run once...

Brandie Tarvin (10/22/2012)

---

[font="Comic Sans MS"]The PI! It needs more slices![/font]

You know what I hate about pie charts?

You can never tell what filling they're using. And it's awfully hard to...

Good article, and I've forwarded it on to one of the Supervisors here as suggested reading for staff...

But, in the last section, in the sentence:

When I was in college, one...

While it was a bit of snarky reply, it's also true. If you want to automate something like this, it's going to have to be scheduled somehow. Either...

Lowell I'll give those a try once my re-restore of the DB on my test box completes...

It only takes about an hour-and-a-half or so to restore...

😉

Thanks!

Jason

Brandie Tarvin (10/17/2012)

---

dwain.c (10/16/2012)

---

Perhaps he was so focused on the future he's never interested in...

Aw yeah!

Just one more win to go for the Tigers!!

I think I'm seeing brooms tomorrow!

😀

Actually, even if they back it up with compression, you can restore it. I tested this recently here at my work, as we have clients who (tightwads) use SQL...