Have you tried running DBCC SHRINKDATABASE on it?

Reading the MSDN article on it, it sounds like it will move all the allocated pages to the beginning of the file, thus...

/best Gene Wilder voice

The name is FronkUnSturm!

TRY TO TAKE OVER THE WORLD!

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