Any version/edition of SQL Server 2008 can restore a compressed backup, however only enterprise can make one.

It does have to be 2008.

You could automate this by looping through the tables and doing a BCP out for a schema, however that doesn't get views/procs/functions.

Jack's suggestion might be the best one.

Be sure that you are now running transaction log backups, and that you took a full backup after the shrink and change from simple.

I'm surprised it took so long for someone to want a bartender. Getting up on stage almost necessitates that for some people!

Yes, you have a hot spot on the table. Note that depending on the CLI, you could have a hot spot there as well. The key is that you also...

For a heap, when you insert data, it adds to to the next page in the last extent (or makes a new page). For deletes, space is marked as deleted,...

Dave,

We'd be happy to work with you to get an article done.

The first step is usually stop and think essay, think about high school/college, and structure things like that. Write...

Grant Fritchey (6/26/2009)

---

Wow! That's big. You're talking about the Scouting one right? I didn't even realize your boy was up to First Class already. That's where they have to be...

One more thing, if you are using this to build your own brand, put it on your resume, you might want your full name.

Ah, not yet. :hehe:

Going to DC, dropping my son off at the National Youth Leadership Conference for a week, spending some time with my brother, speaking in Richmond on Thur...

jwalker25, don't get upset, :-D, we've all been there.

Certainly understand politics, just wanted to be sure this wasn't ignorance or a lack of understanding.

If you were to replace a current...

Sorry, what I meant (and didn't say) was does SQL Server need this stuff on %SystemRoot% for some reason? Or could it be in the /bin for where SQL Server...

You could link the servers together and have one Agent call sp_start_job on the other server.

Alright, I'm leaving for a week. Behave yourselves on the thread.

Good to see some people know what they want. I especially like the pizza one. If I were close, I'd ask for Chichos pizza in Va Beach, but only if...