I'm not 100% certain but I believe its going to be pretty much the same either way. The restore has to write both files so I imagine that if...

If you are using "results to text" the output will be between the 3rd and 4th "(1 row(s) affected)" .

I'm adding a SET NOCOUNT ON to the top of the...

Actually in this case those are privlages we allow our developers anyway. This is just a group that hadn't ever worked on these particular SQL Servers so they didn't...

I ended up granting "View server state" and "View any definition" to the user and that fixed the problem. I'm not sure which of them did it, but I'm...

Unfortunatly its a slightly different problem. My user can't even open the Management node without getting the error "The user does not have permission to perform this action." ...

I've dropped both the trigger and the only unique index. Still no luck.

Just the one table. I even created an exact duplicate, indexes, triggers, data everything and didn't get the same error.

I had a problem getting the patch for SQL Server 2008 to run. I wrote up the process Microsoft used to get me running again here:

http://www.sqlservercentral.com/Forums/Topic1262389-391-4.aspx

You might consider...

After about an hour on the phone with a Microsoft tech they solved it for me. It turns out that it is the same error mentioned in the above...

Thats what I was remembering, thanks! Unfortunatly it looks like that is for database compression, not backup compression.

Thanks anyway though 🙂

It's a good idea Jason and one I may actually use. I thought I remembered a DMF that actually calculated the compression savings ahead of time, without having to...

Yes this is 2008, not 2008 R2.

I've already extracted...

I've checked all of the logs I know of,...

Well I have now tried running sqlsupport.msi from the patch, but that didn't make a difference. I then tried uninstalling sql support, that that didn't help either. And...