NetBackup™ Web UI Microsoft SQL Server Administrator's Guide
- Introducing the NetBackup web user interface
- About NetBackup for SQL Server
- Installation and host configuration
- Monitoring and notifications
- Managing SQL Server discovery and credentials
- About discovery of SQL Server objects
- Managing protection plans for SQL Server
- Create a protection plan to protect SQL Server assets
- Protecting SQL Server
- Restoring SQL Server
- Using instant access with SQL Server
- Prerequisites when you configure an instant access SQL Server database
- Protecting SQL Server with VMware backups
- Create a protection plan to protect SQL Server data with a VMware backup
Overview of NetBackup for SQL Server
The NetBackup web UI provides the capability for backups and restores of SQL Server databases. Instances are automatically discovered in the NetBackup environment and SQL Server administrators can select one or more protection plans that contain the wanted storage, backup, and tuning settings.
The NetBackup web UI lets you perform the following operations:
View discovered instances, databases, or availability groups.
Select protection plans to protect SQL Server assets.
Monitor restore operations.
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.
Table: NetBackup for SQL Server features
Integration with NetBackup role-based access control (RBAC)
The NetBackup Web UI provides RBAC roles to control which NetBackup users can manage SQL Server operations in NetBackup. The user does not need to be a NetBackup administrator to manage SQL Server operations. However, the user still must be a member of the Windows administrator group and have the SQL Server "sysadmin" role.
The following benefits are included:
Management of SQL Server assets
NetBackup automatically discovers SQL Server instances and availability groups in the environment. You can also perform manual discovery. After instances or replicas are registered, the SQL Server workload administrator can select one or more protection plans to protect the SQL Server assets.
Authentication and credentials
SQL Server protection plans support the following:
Backup and restore features
The following features are available for backups and restores:
Stream-based backups and restores
Stream-based backup and restore of SQL Server objects with SQL Server's high-speed virtual device interface.
Snapshot backups and instant access databases
NetBackup can perform backups of SQL Server with snapshot methodology.
You can also create an instant access database from a NetBackup backup image. The database is available almost instantaneously, achieving a near-zero recovery time objective. NetBackup mounts the database's snapshot directly on the backup storage device and treats the snapshot as a normal database.
Support for VMware backups that protect SQL Server
Support for application-consistent, full backups of VMware computers using snapshots. Use of NetBackup Accelerator can also increase the speed of backups.
See the following documents for more information.
NetBackup for VMware Administrator's Guide