Here is what is in my backup job
C:\Program Files\NetApp\SnapManager for SQL Server\SmsqlJobLauncher.exe new-backup –svr 'SHPOLTP02\SHPOLTP02' -ver –verInst 'SHPOLTP02\SHPOLTP02' -mp –mpdir 'i:\SnapMgrMountPoint' -RetainBackups 31 -lb -bksif -RetainSnapofSnapInfo 2 -trlog -noutm -gen –mgmt daily
The backup job works like a champ. Now I am trying to create a clone using a different job. Is this the proper syntax?
C:\Program Files\NetApp\SnapManager for SQL Server\SmsqlJobLauncher.exe clone-backup -svr 'shpoltp02\shpoltp02' -inst 'shpoltp02\shpoltp02' -d shpblog, reporting -tgdb shpblog_new, reporting_new -tgInst 'shpbackup01\shpprodtest' -lastBkup 0
I'm not sure what smsqljoblauncher.exe does, but it doesn't seem to work when creating a clone.
I have also tried the following command at a command prompt and it works like a charm, but when I try to put it in a sql job it fails miserably.
powershell -ImportSystemModules clone-backup -svr 'shpoltp02\shpoltp02' -inst 'shpoltp02\shpoltp02' -d shpblog, reporting -tgdb shpblog_new, reporting_new -tgInst 'shpbackup01\shpprodtest' -lastBkup 0
What am I doing wrong here?