Where do I get this powersheel script from? Do I need to install snap manager for SQL on the windows host housing SQL database and this script will get placed on the path automatically?
This comes with SnapManager SQL so you just need to check if Path is correct
SMSQL_BACKUP_OPTIONS=-svr 'SQL' -d 'SQL\SHAREPOINT', '1', 'WSS_Content' -RetainBackups 7 -lb -bksif -RetainSnapofSnapInfo 8 -trlog -gen -mgmt standard-----Does this option get automaticaly polulated?
Not is doesnt if you want to change from default you must update it
SMSQL_SERVER_NAME=servername-- I guess it is the SQL server name?
Yes servname used in powershell cmdlet
Also NOTE some folks have reported some issues in SC 3.6 with the SMSQL plugin, like it sending the call and not doing anything. If you run into problems like this then you have two options.
1) go with SC 3.5 which has issue where the powershell call hangs if you have an agent running as service (I know lots of bugs)
2) Just forget the plugin and send a powershell CLI call to agent as a APP_QUIESCE_CMD01 and comment out APP_NAME so no plugin is used.
There is a thread here on that issue with other workarounds customers have used but you may not run into issue, these bugs are not a 100% thing, depends on environment.
Regards,
Keith
