Re: [Networker] SQL Module error

Hi,

The SQL module gives trouble when you change the server IP or hostname. When
I faced similar issues, I was told that the SQL server itself stores its
master information on the basis of IP address & host name. I could not even
restore an SQL database with master & msdb database to a new server with
different IP address.

I believe you should try & reinstall the SQL module else revert back to the
original IP.

Regards,
Anuj

----- Original Message -----
From: "Craig Eivers" <craig.eivers AT AU.PIRELLI DOT COM>
To: <NETWORKER AT LISTMAIL.TEMPLE DOT EDU>
Sent: Tuesday, April 13, 2004 3:04 PM
Subject: [Networker] SQL Module error


> Hi There,
>
> I have changed the IP address of our SQL server, the machine name was
> unchanged. I made an enrty in the hosts file and all was working okay.
> However now i notice the error below.
>
> Any help would be greatly appreciated.
>
>
>
> Thanks... Craig.
>
> Apr 12 21:06:18 sn05024au: --- Unsuccessful Save Sets ---
> Apr 12 21:06:18 sn05024au: * sn05030au:MSSQL$: 1 retry attempted
> Apr 12 21:06:18 sn05024au: * sn05030au:MSSQL$: unknown error 160 (0xa0)
> Apr 12 21:06:18 sn05024au: * sn05030au:MSSQL$: Internal system error,
> please see nsr\applogs\xbsa.messages on the client system for reason.
> Apr 12 21:06:18 sn05024au: * sn05030au:MSSQL$: G:\rb_nwmsql_3_1_1
> \nsr\db_apps\bsmsql\nsrsqlado.cpp(1854): ExecuteFailed event arrived.
> Apr 12 21:06:18 sn05024au: * sn05030au:MSSQL$: Microsoft SQL Server
> Provider error:
> Apr 12 21:06:18 sn05024au: * sn05030au:MSSQL$: bsVdiAbort: handle is bad
> Apr 12 21:06:18 sn05024au: * sn05030au:MSSQL$: [Microsoft][ODBC SQL Server
> Driver][SQL Server]Write on 'Legato#52cc5bea-f9c4-466f-901a-fa4e5a89c58d'
> failed, status = 995. See the SQL Server error log for more details..
> Apr 12 21:06:18 sn05024au: * sn05030au:MSSQL$: [Microsoft][ODBC SQL Server
> Driver][SQL Server]BACKUP DATABASE is terminating abnormally..
> Apr 12 21:06:18 sn05024au: --- Successful Save Sets ---
>
> --
> Note: To sign off this list, send a "signoff networker" command via email
> to listserv AT listmail.temple DOT edu or visit the list's Web site at
> http://listmail.temple.edu/archives/networker.html where you can
> also view and post messages to the list.
> =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
>

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=