Veritas NetBackup™ CloudPoint Install and Upgrade Guide
- Section I. CloudPoint installation and configuration
- Preparing for CloudPoint installation
- About the deployment approach
- Deciding where to run CloudPoint
- About deploying CloudPoint in the cloud
- Meeting system requirements
- CloudPoint host sizing recommendations
- Creating an instance or preparing the physical host to install CloudPoint
- Installing Docker
- Creating and mounting a volume to store CloudPoint data
- Verifying that specific ports are open on the instance or physical host
- Deploying CloudPoint using the Docker image
- CloudPoint cloud plug-ins
- CloudPoint storage array plug-ins
- NetApp plug-in configuration notes
- Nutanix Files plug-in configuration notes
- Dell EMC Unity array plug-in configuration parameters
- Pure Storage FlashArray plug-in configuration notes
- HPE RMC plug-in configuration notes
- Hitachi plug-in configuration notes
- InfiniBox plug-in configuration notes
- How to configure the CloudPoint storage array plug-ins?
- CloudPoint application agents and plug-ins
- Microsoft SQL plug-in configuration notes
- Oracle plug-in configuration notes
- MongoDB plug-in configuration notes
- About the installation and configuration process
- Preparing to install the Linux-based agent
- Preparing to install the Windows-based agent
- Downloading and installing the CloudPoint agent
- Registering the Linux-based agent
- Registering the Windows-based agent
- Configuring the CloudPoint application plug-in
- Configuring VSS to store shadow copies on the originating drive
- Creating a NetBackup protection plan for cloud assets
- Subscribing cloud assets to a NetBackup protection plan
- About snapshot restore
- Restore requirements and limitations for Microsoft SQL Server
- Restore requirements and limitations for Oracle
- Restore requirements and limitations for MongoDB
- Steps required before restoring SQL AG databases
- Recovering a SQL database to the same location
- Recovering a SQL database to an alternate location
- Additional steps required after a SQL Server snapshot restore
- Additional steps required after restoring SQL AG databases
- SQL snapshot or restore and granular restore operations fail if the Windows instance loses connectivity with the CloudPoint host
- Disk-level snapshot restore fails if the original disk is detached from the instance
- Additional steps required after a MongoDB snapshot restore
- Additional steps required after an Oracle snapshot restore
- Additional steps required after restoring an AWS RDS database instance
- Protecting assets with CloudPoint's agentless feature
- Preparing for CloudPoint installation
- Section II. CloudPoint maintenance
Microsoft SQL plug-in configuration notes
You can configure the CloudPoint plug-in for Microsoft SQL to discover SQL application instances and databases and protect them using disk-level snapshots. After you configure the plug-in, CloudPoint automatically discovers all the file system assets, SQL instances and databases that are configured on the SQL server host. The discovered SQL assets then appear in the NetBackup user interface (UI) from where you can protect the assets by subscribing them to a protection plan or by taking snapshots manually.
The following types of SQL server deployments are supported:
SQL instances and databases, including standalone databases
You can perform snapshot and restore operations at an instance level. When you take a snapshot of a SQL instance, the snapshot includes all the online databases that are configured in that instance.
Beginning with NetBackup 8.3 release, you can also perform the same set of operations at a single database level. You can take a backup of a individual standalone SQL database that is in an online state and restore it either to the same location or to an alternate location. You are provided with an option to overwrite the existing database. Restore to the same location or alternate location fails if the overwrite existing option is not selected. A disk-level snapshot restore operation restores the database on the target host. The new database is discovered in the next discovery cycle and automatically displayed in the UI.
SQL databases deployed in an Availability Group (AG)
Beginning with NetBackup 8.3 release, you can perform backup and restore operations on SQL databases that are part of an AG. When you take a snapshot of a database in the SQL AG the snapshots are taken from the replica that is configured by the SQL database administrator. You can restore a single AG database to a SQL instance that is configured as a replica in the AG configuration. The AG database can also be restored to a SQL instance that is not part of any AG configuration. When restoring to an AG environment, the database must be removed from the AG before performing the restore.
Before you configure the plug-in, ensure that your environment meets the following requirements:
This plug-in is supported in Microsoft Azure and Amazon AWS environments only.
A supported version of Microsoft SQL server is installed on the Windows instance.
The SQL server instances that you want to protect must be running on a non-system drive.
CloudPoint also does not support SQL server instances that are installed on a mount point.
CloudPoint uses the Microsoft Volume Shadow Copy Service (VSS).
Ensure that you configure VSS to store shadow copies on the same drive (the originating drive) where the database resides.
See Configuring VSS to store shadow copies on the originating drive.
Note:
CloudPoint does not support discovery, snapshot, and restore operations for SQL databases that contain leading or trailing spaces or non-printable characters. This is because the VSS writer goes into an error state for such databases. Refer to the following for more details: