I had exactly the same problem. SP3 on the SQL Server solved this. (SP3 for
SQL SERVER)
Best Regards
Osvaldo Lehman
-----Mensaje original-----
De: Legato NetWorker discussion [mailto:NETWORKER AT LISTMAIL.TEMPLE DOT EDU]En
nombre de Anuj Mediratta
Enviado el: Lunes, 26 de Mayo de 2003 9:11
Para: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Asunto: Re: [Networker] sql backup
Restart the SQL services to temporarily resolve the issue. I have normally
faced this error while restoring SQL data on a fresh server. In that case,
there were two saparate instances of MS SQL installed on the server. When
the first installation got corrupted, the customer disabled the services &
reinstalled another instance. We then reinstalled the entire server with
only one instance of SQL services running & were able to restore data
completely. Check on the SQL instances running in your case.
Also check the configuration of SQL client...SAVE SET-MSSQL:, backup command
nsrsqlsv, user-name & password of the System Administrator of the SQL
server.
Regards,
Anuj Mediratta
Ace Data Devices Pvt. Ltd.
I-132, Kirti Nagar, New Delhi - 110 015.
Mobile : 32334262
Email : anuj AT ace-data DOT com
----- Original Message -----
From: "김인엽" <iykim AT CDDATA.CO DOT KR>
To: <NETWORKER AT LISTMAIL.TEMPLE DOT EDU>
Sent: Monday, May 26, 2003 7:25 AM
Subject: [Networker] sql backup
> Networker ser ver.: 6.1.1
> sql server ver.: mssql 2000
> Networker for sql: 3.1.1.32
>
> Manual backup is normal.
>
> Scheduled backup error messages:
>
> 5 24 15:08:26 backup: * newsoft01db:MSSQL: 1 retry attempted
> 5 24 15:08:26 backup: newsoft01db:MSSQL:: No full backups of this save
set were found in the media database; performing a full backup
> 5 24 15:08:26 backup: * newsoft01db:MSSQL:
(G:\rb_nwmsql_3_1_1\nsr\db_apps\bsmsql\sqlutil.c)1075:gethostbyname failed
> 5 24 15:08:26 backup: * newsoft01db:MSSQL: Microsoft SQL Server Provider
error:
> ? 15:08:26 backup: newsoft01db:MSSQL:: No full backups of this save
set were found in the media database; performing a full backup
> 5 24 15:08:26 backup: * newsoft01db:MSSQL: [Microsoft][ODBC SQL Server
Driver][Shared Memory]ConnectionOpen (Connect())..
> 5 24 15:08:26 backup: * newsoft01db:MSSQL:
> 5 24 15:08:26 backup: * newsoft01db:MSSQL: Cannot login to SQL Server
null.
>
> Any commnet will be appreciated..
>
>
--
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.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
|