how to backup and restore microsoft sql server backup via netbackup
TRANSCRIPT
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
1/19
How to Backup and Restore Microsoft SQL Server Backup
via Netbackup
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
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
2/19
Open NetBackup MS SQL Client from the client machine/PC where MS SQL Server installed as
mentioned in below figure
Now you will find the below window
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
3/19
Now click on Backup SQL Server objects
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
4/19
Now you can see the database(s) which exist on your MS SQL Server
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
5/19
Now select the database which you want to take backup via Veritas Netbackup as i selected and click
onSavein the below figure.
You specify the script name and path where thescript/Batch fileyou want to save at the client side
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
6/19
After click on save a window will offer you to view thescritp/ Batch FIlein the nodepad as shows in the
below figure.
You can see thescript/Batch fileas the below figure shows
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
7/19
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
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
8/19
Howto create script/Batch file for restore of MS SQL Server from VeritasNetbackup
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 nameprojectin the below figure.
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
9/19
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.)
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
10/19
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.
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
11/19
After clicking on OK you will see a window as the below figure
In our case we can see the one Full and 2 differential backups ofprojectdatabase
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
12/19
Now select the Create a move templete fromScriptingbecause we are going to do a redirect
restore(restoring a backup to an alternate PC) activity, and select Recovered from theRecoveryand click
onRestore.
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
13/19
After clicking onRestoreTAB 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 thescript/Batch file as shown in the below figure.
Now you will find the script/Batch file as you can see in the below figure
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
14/19
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.
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
15/19
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
16/19
Specify the restore script/Batch file and click onStart
Click YES to start the backup restoration process.
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
17/19
Now you can see that theprojectdatabase is restored
Prerequesite for redirected restore
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
18/19
Now clck onYes. The procedure"Prerequesite for redirected restore"can start the redirect restore
-
8/10/2019 How to Backup and Restore Microsoft SQL Server Backup via Netbackup
19/19