> The issue I'm trying to pre-empt is that there are some issues where as a 
> backup administrator you don't have direct access to the client, how would 
> you then recover module based (SQL/Exch etc ...) save sets ...



Well, if there ever came a situation where there was a critical database that 
needed to be recovered, I don't see why the DBA would not be there to perform 
the recovery or to be there to verify the data after it was recovered.

But... since you asked... some years ago, I did write up a procedure that can 
be use to perform exactly what you are asking:  recovering a SQL database with 
you having interactive access in the SQL server you are recovering data to.  
This is saved as a knowledge base article esg71967 in powerlink.emc.com.

The article itself shows how you can perform a non interactive and remote 
backup and recovery of SQL using the SQL module, and it is as follows:

-----------------------------------------------------------------------------
esg71967 
Goal: How to perform non-interactive remote SQL backup and restore

Fact: NetWorker Module for Microsoft SQL
Fact: nsrsqlsv
Fact: nsrsqlrc
Fact: Windows

Cause: This unsupported method provides the ability for a remote system to be 
able to contact a Microsoft SQL server and initiate a backup and restore SQL 
operation.

The solution provided uses Windows syntax. If performing this from a remote 
Unix system, the variables has to be exported. For example:

# RUSER=system; export RUSER
# RCMD="nsrsqlsv -l full -b Default -s (nw-server) MSSQL:"; export RCMD


Fix: Ensure that the NetWorker client and NetWorker Module for SQL is installed 
on the Microsoft SQL server

Ensure that the SQL server is defined as a NetWorker client, and that it has 
the remote access set accordingly.

Ensure that the server's User Groups are set accordingly.

Ensure that the system that is initiating the backup and recovery commands is 
also defined as a NetWorker client.

If the remote administrative system is running Microsoft Windows, go to command 
line and define the following variables:

   set RUSER=system
   set RCMD=nsrsqlsv -l full -b Default -s (nw-server) MSSQL:

Then initiate the command with:

   nsrexec -c (sql-client)

where sql-client is the hostname of the SQL server.


In the above example, RCMD defines the command to be run on the Microsoft SQL 
server. Note that this is the NetWorker SQL backup command including the 
necessary parameters.

   -l = backup level
   -b = NetWorker Pool
   -s = name of NetWorker server to backup up to



For example, the following will backup the Northwind database:

  set RUSER=system
  set RCMD=nsrsqlsv -l full -b Default -s (nw-server) MSSQL:Northwind
  nsrexec -c sql-svr

  [1648] [I] 08/26/05 10:22:13 Backing up Northwind...
  [1648] [I] 08/26/05 10:22:13 BACKUP database [Northwind] TO 
virtual_device='Legato#a85dd46d-a270-48a2-9f8f-689f5479d21f' WITH 
name='LegatoNWMSQL'
  [1648] [S] 08/26/05 10:22:15 Backing up of Northwind succeeded.



The next example performs an incremental backup, which backs up the transaction 
logs:

  set RUSER=system
  set RCMD=nsrsqlsv -l incr -b Default -s (nw-server) MSSQL:Northwind
  nsrexec -c sql-svr

  [504] [I] 08/26/05 10:31:31 Backing up Northwind...
  [504] [I] 08/26/05 10:31:31 BACKUP transaction [Northwind] TO 
virtual_device='Legato#5d231bf8-0746-4933-87a0-1194792b2fc8' WITH 
name='LegatoNWMSQL'
  [504] [S] 08/26/05 10:31:32 Backing up of Northwind succeeded.

  nsrsqlsv: MSSQL:Northwind level=incr, 81 KB 00:00:06 1 file(s)



The next example shows how to recover the Northwind database:

  set RUSER=system
  set RCMD=nsrsqlrc -s (nw-server) MSSQL:Northwind
  nsrexec -c sql-svr

  [1648] [I] 08/26/05 10:23:50 Recovering database 'Northwind' ...
  RESTORE database [Northwind] FROM 
virtual_device='Legato#871e918d-24e6-4325-9208-ce3d115fe961'
  [1648] [S] 08/26/05 10:23:52 The restore of database 'Northwind' completed 
successfully.

  Received 2643 KB 1 item(s) from NSR server. 
-----------------------------------------------------------------------------[/quote]

+----------------------------------------------------------------------
|This was sent by wl905 AT yahoo DOT ca via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------

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