I have an SQL server which I have configured the following job through SnapManager for SQL:
"C:\Program Files\NetApp\SnapManager for SQL Server\SMSQLJobLauncher.exe" new-backup –svr 'SQLSERVER1' -d 'SQLSERVER1\INST1', '1', 'DB1', 'SQLSERVER1\INST2', '7', 'DB1', 'DB2', 'DB3', 'DB4', 'DB5', 'DB6', 'DB7', 'SQLSERVER1\INST3', '3', 'DB1', 'DB2', 'DB3' -RetainBackups 6 -lb -bksif -RetainSnapofSnapInfo 3 -trlog -updmir –mgmt standard
All the necessary SnapVault and SnapMirror relationships are already in place. I have also attached a screenshot of the Backup & Verify process (obviously blanking out my server names etc) that shows all the necessary boxes ticked. I do now however have two questions that I hope you are able to help with.
1. I wish to update the SnapMirror after operation. Clearly from the screenshot this tick box is greyed out. The only way I can tick this box is if I click on 'Verify on available SnapMirror destination volumes' then untick this option as well as the 'Verify databases after backup (run DBCC CHECKDB)' option.
As previously stated the SnapMirror relationship already exists so why is this greyed out? I have found a workaround but I am sure that this is not normal.
2. When the job runs there are no error messages displayed and the SnapManager reports that a Full database backup completed sucessfully. When I check the controller and run 'snapvault status' and 'snapmirror status' the lags are still present but when I check the snapshots created on the volumes within System Manager I find that they have been created sucessfully.
Am I missing a trick here? I need the SnapVault and SnapMirror to run. How can I get this to work?
I look forward to all responses in the anticipation that I might get this to work.