MS SQL SERVER Backup and Recovery using NetBackup

NetBackup for SQL Server extends the capabilities of NetBackup for Windows to include backups and restores of SQL Server databases. These capabilities are provided for a Windows client using either a UNIX or Windows NetBackup master server. NetBackup for SQL Server includes a client-based graphical user interface (GUI) program to perform various activities on SQL Server.

NetBackup offers the following types of SQL Server backup policies:

■ SQL Server Intelligent Policies. A single policy protects multiple SQL Server instances that are spread over multiple clients. You select instances for a policy from a list of instances that are automatically discovered in the NetBackup environment.

■ Legacy policies, using clients and batch files. These policies include a list of SQL database clients and a batch file that contains SQL backup commands to run when the backup is scheduled. The user creates this batch file manually or through the NetBackup MS SQL Client interface, which saves the options the user selects to the batch file.

NetBackup for SQL Server includes the NetBackup MS SQL Client to perform various activities on SQL Server, as follows:

■ Restores of databases and database components, which include transaction logs, differentials, files, and filegroups.

■ Configuration of restore options.

■ Monitoring of NetBackup for SQL Server restore operations.

■ (SQL Server legacy policies) Backups of databases and database components and configuration of backup options.


Step By Step MS SQL Server DB Backup and Recovery Configuration:


Create a new database, tables and insert the data using SQL Server management studio.

In Netbackup GUI, Application section add the MS sql server instance and if required create an instance group.

Register the Instance using sql or OS authentication.

Now create MS SQL Server Intelligence Policy.

Select the policy type as MS-SQL-Server.

Create a schedules for Full Backup and Transaction Log Backup.

Select the instance or instance group which you want to take a backup.

Select the backup selection like Whole data base or File groups or Files.

Set the SQL server Intelligence parameters.

Now open Netbackup sql extension GUI:

Select the backup server objects and select the data base to which you want to take a backup.

Select the policy name also.

Now initiate the backup and monitor through Activity Monitor.

Detailed status of backup job.

Sql server intelligence policy initiated and it creates a backup script.

Successfully backup of SQL server DB completed.

Check in Activity Monitor also.

After taking successful backup, add few records to an existing table.

Login to MS sql server backup and recovery client utility, select recovery database objects.

Select the PIT images.

It shows the available images, then select the PIT image to restore and recover the database.

Check the restore job in Activity Monitor.

After successful restore, check the MS sql server Management studio to check records.