Table of ContentsView in Frames

SnapManager for Microsoft SQL Server plug-in

The SnapManager for Microsoft SQL Server plug-in is used to centralize backup operations for Microsoft SQL Server through Snap Creator. Using this plug-in, you can configure tens or hundreds of SnapManager for Microsoft SQL servers through Snap Creator, allowing you to view all of your SnapManager for Microsoft SQL backup jobs and statuses from a single interface.

Unlike the other plug-ins, the SnapManager plug-ins (SnapManager for Microsoft SQL Server and SnapManager for Microsoft Exchange) use PowerShell to communicate with an existing installation of SnapManager. The SnapManager plug-ins require that the SnapManager products are already installed and operating. The SnapManager plug-ins use the new-backup Powershell cmdlet to create a backup through SnapManager. All cloning and restore actions should continue to be driven through the SnapManager interface.

Note: For the latest information about support or to view compatibility matrices, see the Interoperability Matrix.

When using the SnapManager for Microsoft SQL Server plug-in, you must be aware of the following considerations:

The following table provides the SnapManager for Microsoft SQL Server plug-in parameters, provides their settings, and describes them:

Parameter Setting Description
SMSQL_PS_CONF Example: "C:\Program Files\NetApp\SnapManager for SQL Server\smsqlShell.psc1" Specifies the path to the PowerShell configuration file for the SnapManager for Microsoft SQL Server.
SMSQL_BACKUP_OPTIONS Example: -svr 'SQL' -d 'SQL\SHAREPOINT', '1', 'WSS_Content' -RetainBackups 7 -lb -bksif -RetainSnapofSnapInfo 8 -trlog -gen -mgmt standard Specifies the SnapManager for Microsoft SQL Server backup options.

Snap Creator uses a PowerShell cmdlet for new backup.

SMSQL_SERVER_NAME Example: SQL\SHAREPOINT Specifies the SnapManager for Microsoft SQL Server name.
SMSQL_32bit (Y|N) Enables or disables the use of the 32-bit version of PowerShell.