Networker

Re: [Networker] Installation/Configuration of SQL Module/clients?

2003-02-07 13:24:27
Subject: Re: [Networker] Installation/Configuration of SQL Module/clients?
From: Carston Locher <clocher AT LEGATO DOT COM>
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Date: Fri, 7 Feb 2003 10:24:32 -0800
Brian,

You should define a separate instance of the client for the SQL
backups.  In that client instance you would use nsrsqlsv for the backup
command and saveset of MSSQL:.

You do not want to use nsrsqlsv for normal filesystem backups.

The enabler would be required unless you have an enterprise license
(which turns off most if not all license checking) or your NetWorker
server was still in eval mode (this is not true in your case from the
sounds of things).

Thanks,

Carston

On Fri, 2003-02-07 at 10:06, Harris, Brian wrote:
> Will that backup command effect the savesets of:
>
> C:\
> SYSTEM FILES:\
> etc.
>
> ??
>
> Thank you!
>
> -----Original Message-----
> From: Marilyn Schultz [mailto:Marilyn.Schultz AT MITCHELL DOT COM]
> Sent: Friday, February 07, 2003 10:05 AM
> To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
> Subject: Re: [Networker] Installation/Configuration of SQL
> Module/clients?
>
>
> In your client definition you need two things:
>
>         Save set = MSSQL:
>         Backup command = nsrsqlsv
>
>
> Marilyn Schultz
> Mitchell International, Inc.
> San Diego, CA
>
>
> -----Original Message-----
> From: Harris, Brian [mailto:Brian.Harris AT SUMCOUSA DOT COM]
> Sent: Friday, February 07, 2003 9:53 AM
> To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
> Subject: [Networker] Installation/Configuration of SQL Module/clients?
>
>
> So, in my learning how to backup a SQL database, I've discovered that a
> SQL module needs to be installed on the server that is being backed-up.
>
> I've installed said module on the SQL server, and started a backup to
> test (saveset of "MSSQL:" defined), and get the following:
>
> Unsuccessful savesets:
> * msa-ptracker:MSSQL: 5 retries attempted
> * msa-ptracker:MSSQL: save: using 'MSSQL:\' for 'MSSQL:'
> * msa-ptracker:MSSQL: save: cannot stat MSSQL:\: Invalid argument
> * msa-ptracker:MSSQL: save: RPC error: RPC cannot encode arguments
> * msa-ptracker:MSSQL: save: save of MSSQL: to nbacknt.mmc-sil.com failed
>
> So, fun.  Just for kicks, I defined the saveset as "MSSQL:\" this time.
> I got:
>
> Unsuccessful savesets:
> * msa-ptracker:MSSQL:\ 5 retries attempted
> * msa-ptracker:MSSQL:\ save: using 'MSSQL:\' for 'MSSQL:\'
> * msa-ptracker:MSSQL:\ save: cannot stat MSSQL:\: Invalid argument
> * msa-ptracker:MSSQL:\ save: RPC error: RPC cannot encode arguments
> * msa-ptracker:MSSQL:\ save: save of MSSQL:\ to nbacknt.mmc-sil.com
> failed
>
> Is there something I've forgotten to install, either on the NetWorker
> server, or on the SQL server?  I don't have the SQL module in my
> registration section, no temporary enabler code.  Is this something I
> need to do?  Our Legato SE said no, but, I find that I get correct
> answers from non-Legato sources, so...
>
> Thanks for the help!!
>
> Brian Harris
> Systems Administrator
> SUMCO USA
> http://www.sumcousa.com
> (503) 315-6055 (office)
> (503) 315-6125 (fax)
>
>
> --
> 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.
> =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
>
> --
> 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.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=