Sorry I am asking lot of snap creator questions these days. I am very new to snap creator and without your suggestions it is going to be difficult for me
I have a task to configure SQL backups using SnapCreator. In the SC config file , I see couple of options.
SMSQL_PS_CONF="C:\Program Files\NetApp\SnapManager for SQL Server\smsqlShell.psc1" ----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?
SMSQL_SERVER_NAME=servername-- I guess it is the SQL server name?
Does this above configuration mean that Snap Creator will take a consistent snapshot of the SQL database? For the integration with snapvault, I have protection manager in my environment where I will choose the policy and can associate with the dataset. .for the snapvault rentention , is it ok if I specify the retention in the snapvault config file?
If I wish you have weekly backups and retain 3 weekly snapshots and 15 remote snapshots
The retentions are completely ignored all SC is doing is running SnapManager, that is it so SM is responsible for retentions, etc.
Just put anything for retentions it doesnt matter. If you are snapvaulting and SC is doing snapvault then that retention would be used but on primary we would never delete snapshots from SM. Bad things happen if you delete snapshots from SM.