Just thought I'd post an update to our situation in case it helps any others. I was able to pinpoint our database mail problem to the install of KB970894...

I've applied KB970892 on one of my servers and it appears to be working okay. The sysadmins went rogue on us here and applied KB970894 recently on two of...

Thanks to you both. I was having a brain dead moment myself and forgot the point that Steve mentioned that log shipping is simply copying the files between the...

I haven't yet determined the source of the error referring to the 'LocalApplication' directory not being found, but I did figure out that if I do the attach/detach method instead...

Ok, I've located the problem related to server 2 (the one spewing errors about ErrorCode). I thought this was a generic error message but after checking around the internet...

I agree that's what the error appears to be hinting at, but I just tried again and used a completely new database name and set of database files and it...

I picked another server that is using the Local System account for the SQL Agent service account and tried the database copy wizard on it. It also failed, but...

Thanks for the tip Terry. I guess I just figured that if the backups were working fine (which they are), then the correct file system permissions would be set....

Just wanted to say that this is happening to me as well. Here is my configuration in case anyone is interested. Unfortunately, no answer to the problem yet,...

I ran into this problem again on another one of our servers and attempted to use the solution I posted before and it did not fix the problem. So, after...

Figured out my problem after poking around more on Google.

1. reconfigure the surface area

2. DISabling Database Mail stored procedures.

3. Restart SQL Agent

4. REenable Database...