[Networker] SQL / Exchange restores
2010-06-23 22:34:44
> 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
|
|
|