Overview of NetBackup for SQL Server
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.
In this guide, Microsoft SQL Server is referred to as SQL Server. NetBackup for Microsoft SQL Server is referred to as NetBackup for SQL Server.