Networker

Re: [Networker] scipted backup and restores using NMM for MSSQL databases

2010-05-27 14:41:18
Subject: Re: [Networker] scipted backup and restores using NMM for MSSQL databases
From: "Werth, Dave" <dave.werth AT GARMIN DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Thu, 27 May 2010 11:33:41 -0700
I don't know if this will help you but I start a Networker Group from a client 
with a script.  I'm not running the backup commands directly but merely 
signaling the group to start.  The script I use is below.  It's written for the 
Korn Shell on Solaris but there must be a way to do it in Windows as well.  
Hope it helps.

Dave

Dave Werth
Garmin AT, Inc.
Salem, Oregon
-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On 
Behalf Of Mark Leese
Sent: Thursday, May 27, 2010 1:56 AM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: Re: [Networker] scipted backup and restores using NMM for MSSQL 
databases

Thanks for the responses, yes this helps. We need the ability to script so we 
will be sticking with standalone MSSQL module.

==============================
# Save oracle archived redo log files through NSR commands.
# Note: This script is called by another script that
#       determines if it needs to be run.
#
# start oracle redo logs save
echo "
  . type: NSR group;
  name: ora-redologs
  update Autostart: Start now" | nsradmin -s <NetworkerServer> -i -
 
# Check status, wait until done
StatF=/tmp/RDLstat$$.tmp
sgDone=0
while [ sgDone -eq 0 ]
do
 sleep 30
 echo "
  show status
  print type: NSR group;
  name: ora-redologs" | nsradmin -s <NetworkerServer> -i - > $StatF
#
  if grep "status: idle;" $StatF
  then
        sgDone=1
  fi
done
 
# clean up
rm -f $StatF
 
echo "savegrp done"
===================================

--------------------------------------------------------------------------------
This e-mail and any attachments may contain confidential material for the sole 
use of the intended recipient. If you are not the intended recipient, please be 
aware that any disclosure, copying, distribution or use of this e-mail or any 
attachment is prohibited. If you have received this e-mail in error, please 
contact the sender and delete all copies.
 
Thank you for your cooperation.

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