Thanks for the idea but I get: "SQL Mail session is already started." Everything worked just fine until I restarted the SQL service on the machine. It's almost...

My problem is not one where a particular job step fails or hangs, a step successfully completes and then the job itself just hangs. Usually the job executes just...

If I remember correctly, SSIS has a bug when it comes to 'put'ting data on a UNIX server. The last I heard from MS is that a fix will...

I found the problem, or rather my tech support staff did on Christmas day; the process response (idle?) time on the VPN was set too short. Apparently, when the...

Yup, did a 'refresh', shut down SSMS and re-started, no joy. I am running this over a VPN and one of network techs said this could cause an issue;...

No, the recovery finishes. It's just that afterward the blasted thing stays in a 'Restoring' state.

Thanks.

Tim

Sorry, I forgot that. I do have the path for the backup file fully defined.

Sure:

restore database ds2

from disk = 'ds1.bak'

with recovery,

...

Yup, I am using 'With Recovery'.

Yes; I turned Writeback off then on. However, I doubt that this had been done prior to the original failure. Is there something in the writeback scenario that...

Thanks

Steve -

I thought 'Analysis Services' was the correct forum; where should I have put this?

I stumbled on the answer, it had to be re-created from scratch. Thanks anyway.

Tim

My work around wasn't elegent, but I ended up using .txt files and running the ftp executable.