KEMBAR78
Netbackup Client Configuration: SQL Restore | PDF | Backup | Databases
Scribd
Upload
553 views8 pages

Netbackup Client Configuration: SQL Restore

To restore a SQL database using NetBackup, first launch the NetBackup MS SQL Client on the SQL server. Select the database to restore and configure the restore settings, including creating a script to move the database to a new location and rename it. Edit the script to specify the new database name and path. Create a NetBackup job using the policy and call the script, which will run the restore according to the instructions in the script. Monitor the job to completion and deactivate the policy after it finishes.

Uploaded by

AbdulrahMan Muhammed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
553 views8 pages

Netbackup Client Configuration: SQL Restore

To restore a SQL database using NetBackup, first launch the NetBackup MS SQL Client on the SQL server. Select the database to restore and configure the restore settings, including creating a script to move the database to a new location and rename it. Edit the script to specify the new database name and path. Create a NetBackup job using the policy and call the script, which will run the restore according to the instructions in the script. Monitor the job to completion and deactivate the policy after it finishes.

Uploaded by

AbdulrahMan Muhammed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 8

NetBackup Client Configuration

SQL Restore
To do a SQL restore we have to launch Netbackup MS SQL Client from a SQL
server I usually do all restores to Cbicdg-Votan then export the database and copy it to
the user location.

Next we want to configure the SQL properties to do the restore. Click on File,
Restore SQL Server Objects.

1
NetBackup Client Configuration

Select the SQL server from the drop down menu or type the server name in the
SQL Host area. Select the date range you want and click OK.

2
NetBackup Client Configuration

Now select the database you want to restore I selected an Incremental backup for
this restore.

3
NetBackup Client Configuration

Once you selected the database you need to configure the rest of the settings.
Click on the drop down arrow for scripting and choose Create a move template this will
allow you to move it to a different server. Bullet Stage full recovery. Click the drop
down menu for Recover and select Recovered. Then bullet Save and click on restore.

4
NetBackup Client Configuration

Type the name of the script you want I usually use the name of the database being
restored. This time we will call it testrestore.bch (remember this name)

Select Yes which will open the script file in notepad.

5
NetBackup Client Configuration

The script file will need to be edited for the database to be moved to the new
server with a different name.
Color Code
Yellow- Things to read
Red- Things to delete
Blue- New database name
Green- New database path which has to be already created.

6
NetBackup Client Configuration

This is what the script would look like if we were restoring it to cbicdg-Votan.
Data would be on E:\Patches and the new database name would be test restore. The lines
in orange were modified then the script was saved.

7
NetBackup Client Configuration

Once the script configured we need to go back to the NetBackup


Administration Console to create the job that calls this script. Go to policies and select
the DB-MSSQL-DB-restore-Full policy. You will notice that Cbicdg-Votan is all ready a
client of this group so we won’t have to add it. Right click the Backup selection on the
bottom and choose change.

Now we have to take out the old script name and put in the new script name
called testrestore.bch. and select OK.

Now right click on the policy and click on Activate. Then right click on the policy
and select manual backup. Then click OK and the job will start running you can monitor
it from the Activity Monitor. When the restore is finished set the Policy back to
Deactivated by right clicking the policy.

You might also like