Features of NetBackup for SQL Server — NetBackup 8.1.2 | Cohesity Documentation

Ransomware attackers specifically target and attempt to destroy backup systems to increase the probability of payment. Hardening your system is critical. Please ensure you have reviewed your platform security using the Security Hardening Checklist

Features of NetBackup for SQL Server — NetBackup 8.1.2 | Cohesity Documentation

Features of NetBackup for SQL Server

Table: NetBackup for SQL Server features describes the features for NetBackup for SQL Server.

Table: NetBackup for SQL Server features

Feature	Description
NetBackup integration	Full integration with the NetBackup master server and media manager. Job monitoring from the server and the NetBackup MS SQL Client interface.
SQL Server Intelligent Policy	Intelligent Policy offers the following benefits: Create a single policy to protect multiple SQL Server instances or the databases in an instance. These instances can be spread over multiple clients. Include a full, differential, and transaction log backup in the same policy. Schedule frequent backups of transaction logs. You are not required to know SQL Server commands or to write and use batch files. Instead, this feature automatically generates the batch files at run-time.
SQL Server instance management	NetBackup automatically discovers SQL Server instances in the environment. The user can view and register these SQL Server instances, which are used to build a SQL Server Intelligent Policy. The user can also use instance groups to organize instances and, optionally, automatically register instances.
Authentication and credentials	SQL Server Intelligent Policy supports the following: Windows authentication and Windows Active Directory authentication. With the proper configuration, you do not have to run the NetBackup Service Account as a privileged SQL Server user on the client. The SQL Server DBA can manage the SQL Server credentials and instance registration independently from the NetBackup administrator, with the nbsqladm command.
Backup and restore features	NetBackup supports the backup of databases, files, filegroups, transaction logs. In addition, you can perform copy-only backups and backups of only read-write filegroups. An administrator that uses the NetBackup MS SQL Server Client can browse backups and select the ones to be restored.
Automated backups	Administrators can set up schedules for automatic, unattended backups for instances on local or remote hosts across the network. These backups can be full, differential, or transaction log backups and are managed entirely by the NetBackup server from a central location. The administrator can also perform manual backups.
Snapshot backups and restores	NetBackup can perform backups of SQL Server with snapshot methodology. Also available are off-host backups, Instant Recovery, and backups with a hardware provider.
Stream-based backups and restores	Stream-based backup and restore of SQL Server objects to tape or disk with SQL Server's high-speed virtual device interface.
Redirected restores	Restore SQL Server objects to different locations.
Legacy SQL Server policies	Support for the legacy backup policies that use batch files and a list of clients.
Performance tuning	Performance tuning with policy configuration, including the following options: backup stripes, transfer size, buffer usage, and the option to skip any databases that are unavailable.
Support for high availability (HA) environments	SQL Server Intelligent Policies can protect the following HA environments: SQL Server clusters Log-shipping Note that the same caveats exist for Intelligent Policies as for legacy SQL Server policies. Legacy SQL Server policies can protect the following environments: SQL Server clusters SQL Server AlwaysOn Availability Groups™ (AGs) Database mirroring Log-shipping For information on the HA solutions that SQL Server supports, refer to your SQL Server documentation.
Compression	Compression increases backup performance over the network and reduces the size of the backup image that is stored on the disk or tape. The user can select NetBackup compression or SQL Server compression. Both options should not be enabled for the same policy.
NetBackup encryption	When the Encryption attribute is enabled, NetBackup encrypts the backup for the instances or clients that are listed in the policy.
Multistreaming	Ability to use multiple stripes during a backup.
Support for VMware backups that protect SQL Server	Support for application-consistent backups of VMware computers using the VMware intelligent policy. The VMware intelligent policy includes three features that NetBackup for SQL Server supports: VMware snapshots, Replication Director (RD) snapshots, and Accelerator. Only full backups are supported on these three variations of the VMware intelligent policy. Hyper-V is not supported at this time. See the following documents for more information on VMware intelligent policy, RD, and Accelerator. NetBackup for VMware Administrator's Guide NetBackup Replication Director Solutions Guide NetBackup Administrator's Guide, Volume I

Feedback

Was this page helpful?

Feedback

Was this page helpful?