Thanks for the replies. How can I successfully install sp2 if the service won't start? It's my understanding that part of the sp process is to start and...

That's your issue, the account running the job needs write access to the location you are writing to.

Try mapping a drive to the \\temp-shed-40\public\location as the user account (i.e. 'connect using a different user name' and see if you can manually copy files there.

Also, where is...

I'm very cynical on this one.....especially because of some of my vendors (i.e. consultants) but "valued partnership" always makes me shake my head.

Ok, call me dopey....

I changed the service account through Windows services instead of config. mgr. I went into Config. Manager, changed it back to admin, let the service refresh,...

All I see in the start value is the name of the variable (i.e. @cost). The requirement is to be able to see what value is actually passed in...

THANK YOU! I read through the articles (ok, it took me about 3 reads to understand the theory) and they are very helpful. I've tweeked the code a...

Thank you for your responses! Now, to attempt the implementation....

Nope, this is simply for DR purposes so these scripts are a great starting place; thanks!

I have a question which is probably very stupid but I can't seem to get...

The names are always changing because I create them as the DBNAME_DATE_TIME.trn.

I couldn't live without this site!! The best example is when a dinosaur of a programmer at my company refused to allow me (as the DBA) to change the...

Thanks for the replies!  I changed the job step to use cmdexec and pointed it to my batch files and it works like a charm.  For some reason; it doesn't...

I think so because i can run the bat file successfully from the command line; just not mgt studio or through the agent.

Thanks for the reply! I tried it both ways and even with the ip address and it still gives the same errors.

Thank you!  It works perfectly.