Networker

[Networker] Two SQL instances

2005-05-19 22:40:44
Subject: [Networker] Two SQL instances
From: "Rohrich, James" <James.Rohrich AT UOP DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Thu, 19 May 2005 19:26:37 -0500
I am trying to backup two instances of SQL on a non Clustered 2003
server which is running SQL2000. NW 7.1.1 and SQL module 4.0 is being
used. According to the manual you can only save one instance at a time,
so the two instances are set to run in different jobs. 

Because of the length of name of the second instance the command cannot
be entered in the remote option field. Have tried the following:

nsrsqlsv.exe -s backupserver -b Weekly  -i D:\\nsr\\bin\\jgrfile

The file jgrportal constains the following:

MSSQL$NAMEOFINST1\\restofname:

\\ was used since part of the instance has a slash in it.

In the gui MSSQL is used as the saveset name.

The above seems to ignore what was entered and only saves the first
instance.

James Rohrich
UOP LLC
25 E. Algonquin Rd.
Des Plaines, Illinois 60016
Tel: (847) 391-3958
james.rohrich AT uop DOT com


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

<Prev in Thread] Current Thread [Next in Thread>
  • [Networker] Two SQL instances, Rohrich, James <=