I wrote a SP to backup 10 SQL SERVER DATABASES. Sometimes, we got the error like this.


02/12/27 23:04:51.10 ods Error : 17824, Severity: 10, State: 0
02/12/27 23:04:51.10 ods Unable to write to ListenOn connection '\\.\pipe\sql\query', loginname 'sa', hostname ''.
02/12/27 23:07:27.82 ods OS Error : 232, The pipe is being closed.

How do we fix this?

Jim