Can anyone confirm whether this is the case? Has anyone actually asked MS for support on an Express instance?

The page linked to above is for SQL Express 2005. I can't...

Thanks, all. As some of you predicted, we still had a transaction log backup job running against the primary database - completely seperate from the log shipping sequence. I removed...

Yeah, we've already started down that path. Unfortunately, it's hard to get a good feel for each offering in the short trial period. So, I was hoping there was already...

I'll bump this a single time, hoping that someone has some info... anything?

Thanks for the fast responses, guys.

It was quite a few problems - some were key related, others were not.

(Also, as a side note, I have no real control over the schema of the PROD...

Unfortunately, we are forbidden (for various, nonsensical reasons) from pulling data from the production DB outside of the overnight window.

So, would you recommend something other than snapshot replication for this?...

So, what's the best type of replication for this kind of setup?

My situation is - I need to, essentially, copy the database from a production server to a reporting server...

In in the interest of helping out anyone else that runs into this...

I removed the two SQL 2005 components, via the add/remove programs interface, without any problems.

Cheers.

Bumping this one time, just in case it got missed by someone.

Anyone...?

OK... I figured it out... and it was ridiculously simple.

As I mentioned, the query that is being run is pretty straight-forward and simple. Here's a slightly modified version (to protect...

Still no luck...

I ran:

EXECUTE msdb.dbo.sysmail_add_principalprofile_sp

@profile_name = 'SQL Mail',

@principal_name = 'COMPANY\xxxxxxxx',

@is_default = 0 ;

And got the same error.

Anything else I might be missing?

Nah, no DENY on sp_send_dbmail...

Thanks Jason. I've got our server team looking at that link and (hopefully) fixing things.

Thanks guys, I think those last two posts contain the info I was looking for.

FWIW, I see that you can do multi-site clustering without the SAN, I'm just not sure...