Networker

Re: [Networker] sql backup

2003-05-27 05:21:08
Subject: Re: [Networker] sql backup
From: Osvaldo Lehmann <olehman AT AQB DOT CL>
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Date: Mon, 26 May 2003 09:31:15 -0400
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.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

<Prev in Thread] Current Thread [Next in Thread>