Where I work, we resolved this issue by using a function that returns a table. So, the report passes the comma delimited string of values to the stored procedure...

Hi,

Thanks very much for the information. What if we're running an active/active cluster? Do you happen to know what the impact of that would be?

... forgot to mention, - I edited the configuration file on both nodes.

Hi,

Yes, I edited the MsDtsSrvr.ini.xml file to include ServerName\Instance. It's really maddening. The documentation that my research has turned up makes it sound...

Hi,

Thank you for responding. What line are you referring to?

I did modify the files on both nodes to refer to the msdb folder and I also...

No the WITH MOVE options are correct.  I tested my restore process several times and each time it resulted in this 3rd record being placed into sysaltfiles.

I've also run a...

Hi,

This db is not read-only.   Also I forgot to mention that the .bak was provided to me from a client.  That explains why the path in the 3rd record...

I appreciate your willingness to take the time to provide thoughtful and detailed suggestions.  It's nice to know there's a resource like this site that I can turn to with...

I found another job that was scheduled hourly and failing every time (it was trying to back up a non-existent database).  The job is no longer needed so I dropped...

Hi Folks,

This response hopefully answers the various questions that have been asked since the last time I logged in...

No it's not the Master db and yes, the db I'm trying...

No 3rd pty tools are used and yes, it's being backed up to a local drive.   I checked the event logs for any entries before and after the failure to...

Hi Again,

to test the length limits, I piggybacked the password as follows

0123456789abcdefghijklmnopqrstuvwxyzZZZZZZZZZZZZZZ0123456789abcdefghijklmnopqrstuvwxyzZZZZZZZZZZZZZZ

and thereby made it 100 characters long, and it failed.  I was able to use your 50-character pwd though. ...