How to Backup and Restore Microsoft SQL Server Backup via Netbackup

Posted on July 15, 2011

0


Today we discuss how Veritas Netbackup do Backup and Restore of Microsoft SQL Server via very easy snapShot procedure. In our case we have a environment of windows2003 server with Veritas Netbackup 6.5.
Note: You must have installed Veritas Netbackup client on the client machine where MS SQL Server is installed.

In this article we will discuss:

  • Howto create script/Batch file for backup of MS SQL Server from Veritas Netbackup
  • Howto mention the backup script/Batch file in the Veritas Netbackup policy
  • Howto create script/Batch file for restore of MS SQL Server from Veritas Netbackup
  • Howto run the restore script/Batch file to restore the backup
  • Prerequesite for redirected restore

 

Howto create script/Batch file for backup of MS SQL Server from Veritas Netbackup

 

Open NetBackup MS SQL Client from the client machine/PC where MS SQL Server installed as mentioned in below figure
imagebrowser image

Now you will find the below window

imagebrowser image

Now click on Backup SQL Server objects

imagebrowser image

Now you can see the database(s) which exist on your MS SQL Server

imagebrowser image

Now select the database which you want to take backup via Veritas Netbackup as i selected and click on Save in the below figure.

imagebrowser image

You specify the script name and path where the script/Batch file you want to save at the client side

imagebrowser image

After click on save a window will offer you to view the scritp/ Batch FIle in the nodepad as shows in the below figure.

imagebrowser image

You can see the script/Batch file as the below figure shows

imagebrowser image

Now the script/Batch file is created who will help you to take the backup via Veritas Netbackup.

Howto mention the backup script/Batch file in the Veritas Netbackup policy

in our case we imagine that the backup policy is already created in the Veritas Netbackup

imagebrowser image

Howto create script/Batch file for restore of MS SQL Server from Veritas Netbackup

In the restore activity which we are now going to perform.
Note:
In our this restore activity we suppose that we are going to restore MS SQL Server on a different client machine and as you can see there is no database of name project in the below figure.

imagebrowser image

Now open the Netbackup MS SQL Client and click on Restore SQL Server objects. From here we are going to create a Restore Script.

(Note: Open the “Netbackup MS SQL Client” from the destination where you want to restore the backup.)

imagebrowser image

if you are restoring backup on the same machine then you mentioned same name on SQL Host and Source Client. if you are restoring MS SQL backup on a different PC then you must follow the “prerequesite for redirected restore”  in this article and then click on OK.

imagebrowser image

After clicking on OK you will see a window as the below figure

imagebrowser image

In our case we can see the one Full and 2 differential backups of project database

imagebrowser image

Now select the Create a move templete from Scripting because we are going to do a redirect restore(restoring a backup to an alternate PC) activity, and select Recovered from the Recovery and click on Restore.

imagebrowser image

After clicking on Restore TAB you will mentioned the path (where you want to keep the restore script/Batch file )and the script/Batch file name. After doing this Veritas will offer you to view the script/Batch file as shown in the below figure.

imagebrowser image

Now you will find the script/Batch file as you can see in the below figure

imagebrowser image
As the above outline figure you can see where the backup exist. Now in the below figure we specify the path where we want to restore the backup and also un hash the outline lines and then save this script/Batch files.

imagebrowser image

Howto run the restore script/Batch file to restore the backup

Open the Netbackup MS SQL Clients and click on Manage script files

imagebrowser image

Specify the restore script/Batch file and click on Start

imagebrowser image

Click YES to start the backup restoration process.

imagebrowser image

Now you can see that the project database is restored

imagebrowser image

Prerequesite for redirected restore

 

imagebrowser image

imagebrowser image
Now clck on Yes. The procedure “Prerequesite for redirected restore” can start the redirect restore

imagebrowser image

 

Also create a No. Restriction file for an alternate restore

(No.Restrictions is Case sensitive)

Advertisements