VMware policy with "SQL Server Recovery" enabled

[perez_cmz]

I'm testing a VMware policy with "SQL Server Recovery" enabled, but the job is failing with status error 198 (no active policies contain schedules of the requested type for this client).

Detailed status:

07/18/2014 11:08:35 - Info nbjm (pid=5251) starting backup job (jobid=240405059) for client SV204859.ztbpre.icbpre.commerzbank.com, policy US_STI_VMWARE_SQL_TEST, schedule INCR_5W
07/18/2014 11:08:35 - Info nbjm (pid=5251) requesting MEDIA_SERVER_ONLY resources from RB for backup job (jobid=240405059, request id:{63923490-0E8D-11E4-94EE-91B5C52E6961})
07/18/2014 11:08:35 - requesting resource US_STI_NSIDD01_LSU01_MS1
07/18/2014 11:08:35 - requesting resource nmadep11.zit.commerzbank.com.NBU_CLIENT.MAXJOBS.SV204859.ztbpre.icbpre.commerzbank.com
07/18/2014 11:08:35 - requesting resource nmadep11.zit.commerzbank.com.NBU_POLICY.MAXJOBS.US_STI_VMWARE_SQL_TEST
07/18/2014 11:08:35 - requesting resource nmadep11.zit.commerzbank.com.VMware.Datastore.SI_rep_sql_ds02
07/18/2014 11:08:35 - requesting resource nmadep11.zit.commerzbank.com.VMware.ESXserver.sv188921.ztb.icb.commerzbank.com
07/18/2014 11:08:35 - requesting resource nmadep11.zit.commerzbank.com.VMware.vCenter.sv188865.ztb.icb.commerzbank.com
07/18/2014 11:08:46 - granted resource  nmadep11.zit.commerzbank.com.NBU_CLIENT.MAXJOBS.SV204859.ztbpre.icbpre.commerzbank.com
07/18/2014 11:08:46 - granted resource  nmadep11.zit.commerzbank.com.NBU_POLICY.MAXJOBS.US_STI_VMWARE_SQL_TEST
07/18/2014 11:08:46 - granted resource  nmadep11.zit.commerzbank.com.VMware.Datastore.SI_rep_sql_ds02
07/18/2014 11:08:46 - granted resource  nmadep11.zit.commerzbank.com.VMware.ESXserver.sv188921.ztb.icb.commerzbank.com
07/18/2014 11:08:46 - granted resource  nmadep11.zit.commerzbank.com.VMware.vCenter.sv188865.ztb.icb.commerzbank.com
07/18/2014 11:08:46 - estimated 0 kbytes needed
07/18/2014 11:08:46 - begin Parent Job
07/18/2014 11:08:46 - begin Application State Capture: Step By Condition
Operation Status: 0
07/18/2014 11:08:46 - end Application State Capture: Step By Condition; elapsed time 0:00:00
07/18/2014 11:08:52 - Critical ascc (pid=7022) MSSQL: Unsupported schedule type.
Operation Status: 198
07/18/2014 11:08:53 - end Parent Job; elapsed time 0:00:07
Operation Status: 198
no active policies contain schedules of the requested type for this client  (198)

I believe it's looking for an "Automatic Backup" schedule, but the VMware policy with "SQL Server Recovery" enabled does not show this as an option when I try to create a new schedule.

Any assistance is greatly appreciated.
 

[Mark_Solutions]

It can also do this when the client type is not supported or something is wrong...

Can you confirm that you have installed the NBU client on the SQL Server and have installed the Symantec VSS Provider on it too?

[perez_cmz]

I do have the nbu client installed on the SQL server. How/where can I check to see if the Symantec VSS Provider is installed as well ?

[RiaanBadenhorst]

Hello,

You have to install it manually, its not installed with the client by default.

http://www.symantec.com/docs/HOWTO72089

[perez_cmz]

I've installed the Symantec VSS Provider, and rerun the job. The full job was successful, but now the incremental failed as follows.

07/21/2014 15:32:28 - Info nbjm (pid=5251) starting backup job (jobid=240422298) for client SV204859.ztbpre.icbpre.commerzbank.com, policy US_STI_VMWARE_SQL_TEST, schedule INCR_5W
07/21/2014 15:32:28 - Info nbjm (pid=5251) requesting MEDIA_SERVER_ONLY resources from RB for backup job (jobid=240422298, request id:{C058A27C-110D-11E4-9DF7-5BB5263CC9E2})
07/21/2014 15:32:28 - requesting resource US_STI_NSIDD01_LSU01_MS1
07/21/2014 15:32:28 - requesting resource nmadep11.zit.commerzbank.com.NBU_CLIENT.MAXJOBS.SV204859.ztbpre.icbpre.commerzbank.com
07/21/2014 15:32:28 - requesting resource nmadep11.zit.commerzbank.com.NBU_POLICY.MAXJOBS.US_STI_VMWARE_SQL_TEST
07/21/2014 15:32:28 - requesting resource nmadep11.zit.commerzbank.com.VMware.Datastore.SI_rep_sql_ds02
07/21/2014 15:32:28 - requesting resource nmadep11.zit.commerzbank.com.VMware.ESXserver.sv188921.ztb.icb.commerzbank.com
07/21/2014 15:32:28 - requesting resource nmadep11.zit.commerzbank.com.VMware.vCenter.sv188865.ztb.icb.commerzbank.com
07/21/2014 15:32:29 - granted resource  nmadep11.zit.commerzbank.com.NBU_CLIENT.MAXJOBS.SV204859.ztbpre.icbpre.commerzbank.com
07/21/2014 15:32:29 - granted resource  nmadep11.zit.commerzbank.com.NBU_POLICY.MAXJOBS.US_STI_VMWARE_SQL_TEST
07/21/2014 15:32:29 - granted resource  nmadep11.zit.commerzbank.com.VMware.Datastore.SI_rep_sql_ds02
07/21/2014 15:32:29 - granted resource  nmadep11.zit.commerzbank.com.VMware.ESXserver.sv188921.ztb.icb.commerzbank.com
07/21/2014 15:32:29 - granted resource  nmadep11.zit.commerzbank.com.VMware.vCenter.sv188865.ztb.icb.commerzbank.com
07/21/2014 15:32:29 - estimated 0 kbytes needed
07/21/2014 15:32:29 - begin Parent Job
07/21/2014 15:32:29 - begin Application State Capture: Step By Condition
Operation Status: 0
07/21/2014 15:32:29 - end Application State Capture: Step By Condition; elapsed time 0:00:00
Operation Status: 198
07/21/2014 15:32:32 - Critical ascc (pid=4739) MSSQL: Unsupported schedule type.
07/21/2014 15:32:33 - end Parent Job; elapsed time 0:00:04
Operation Status: 198
no active policies contain schedules of the requested type for this client  (198)
 

[RiaanBadenhorst · Accepted solution]

Hello,

Incrementals are NOT supported.

0. Limitations of using a VMware policy to protect SQL Server

   The following limitations exist when you configure a VMware policy to protect SQL Server:

   • VMware incremental backups of SQL Server are not supported with this version of NetBackup. However, the use of Accelerator may increase the speed of full backups.

[perez_cmz]

Riaan,

Can you please let me know where this is documented ? I need to present this to the dba's. Thank you

[RiaanBadenhorst]

http://www.symantec.com/docs/DOC6479

Chapter 6

[perez_cmz]

Thank you