Networker

Re: [Networker] Backing up multiple instances of MSSQL server db's

2011-04-07 16:29:46
Subject: Re: [Networker] Backing up multiple instances of MSSQL server db's
From: "Olenick, Jason (EXP)" <jason.olenick AT LMCO DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Thu, 7 Apr 2011 16:17:37 -0400
In the client config, under save sets, add a line for each instance you want 
backed up.

Ex:

MSSQL$INSTANCE1:
MSSQL$INSTANCE2:
MSSQL$INSTANCE3:

Also make sure you've supplied a remote user & password that has sufficient 
rights for all instances.

When you want to do a restore, launch the Networker User for SQL Server client 
and it will ask you which instance you want to work with.

Hope this helps.

Jason

-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On 
Behalf Of James T Proctor
Sent: Thursday, April 07, 2011 3:16 PM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: EXTERNAL: [Networker] Backing up multiple instances of MSSQL server 
db's

We are running MSSQL 2005 on Win2k3.  There are multiple instances of 
databases with the same db name.  When I go to do a restore it is showing 
only one database instance.  How do I configure the backup for two 
instances?  Right now I am under savesets using MSSQL: 

Win2K3     
Networker 7.5.1 

Jim Proctor


Jim Proctor
Virtual Team Lead
USGS/NGTOC III
Rolla, Missouri
jproctor AT usgs DOT gov
(573)308-3521


To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

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