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.
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: