I've been working my way through the documentation and posts on this forum while trying to do a simple configuration in Snap Creator for SnapManager for SQL. This should be a very simple thing but I can't figure out how to configure it and there are no examples. I simply want to have Snap Creator schedule my SnapManager for SQL backups. Do I need a Standard Configuration or a Plug-in Configuration, or do I need a Standard that calls a Plug-in? I've even saw a post that seemed to ignore the built-in SMSQL plugin and said to just use the PRE command.
What I'm really looking for is a step by step on how I set this up. I'm not looking for an idiots guide, but I would like details on where I need to tweak the config (if any) after the GUI is complete. I'm quite experienced with NetApp and SnapManager, but the Snap Creator documentation seems to be quite lacking in this scenario and I'm at a loss.
The SnapManager for SQL plug-in is one of the plug-ins listed under application plug-ins.
Just go through the wizard as shown in the above video and select the SnapManager for SQL instead of the one in the video and fill out the needed parameters.
If you're doing this through the CLI, here is some of the info in the docs that I have:
Note: The GUI does most of these steps for you as you go through the wizard.
Configure Snap Creator for SMSQL
Complete the following steps to configure Snap Creator for SMSQL:
Confirm that SMSQL is installed on the system.
Run the SMSQL Configuration Wizard to verify that all components are stored on NetApp storage.
Confirm that Snap Creator is installed. In instances where Snap Creator Server exists on a remote server, install Snap Creator Agent on SMSQL server and uncheck “Start agent as service”. For SMSQL plug-in the agent needs to be started from command line or via batch file.
Configure the new Snap Creator configuration File:
Define SMSQL_PS_CONF= "C:\Program Files\NetApp\SnapManager for SQL Server\smsqlShell.psc1".
Define SMSQL_BACKUP_OPTIONS= -svr '%%SERVERNAME%%' -d '%%SERVERNAME%%','1','%%SQLINSTANCE%%' -RetainBackups 8 -lb -bksif -RetainSnapofSnapInfo 8 -trlog -ver -gen -mgmt daily # change all %% parameters with the needed parameters.
Define SMSQL_SERVER_NAME=<servername> # in lowercase.
Run Snap Creator and verify that the SMSQL PowerShell new-backup completes successfully.
Table 2 shows an overview of the SMSQL plug-in parameters.
Table 2) SMSQL plug-in parameters.
The database application name
Volumes on which the database resides
Storage name, user name, and password
Storage controller name with login credentials
Protocol for API communication
Communication port for HTTP
Path to the PowerShell configuration file for SMSQL
SMSQL backup options. (Snap Creator uses a PowerShell new-backup cmdlet.)
SMSQL server name (enter in lowercase)
Y or N
Setting to enable use of 32-bit version of PowerShell
Ok, I walked through the GUI config (again) and in the end I have a config not much different from my first attempt. The job runs, but does absolutely nothing?!?!? I've pasted the config below, but replaced the server and controller names as well as the passwords with placeholders. I also removed the plugin sections such as oracle, DB2, etc to reduce the size of this post. I've removed nothing from the live file.
Should any of the options below be changed to a Y?