If you are using the Cluster Client to backup the SQL Server/ Instance (which is recommended so that we can follow the failover events) you would want to make sure that the Job results directory is configured on a Shared Drive that follows that specific SQL Cluster Group during failover.
A couple of questions about the configuration if I may?
For this SQL Server, is this a Standalone SQL Server, or is it a server that is participating in a Microsoft Windows Failover Cluster, or perhaps a Microsoft SQL Server Availability Group Cluster?
Also, are you using a Service Account configured on the properties of the SQL Server IDA, or on the Instance Level?
Is the Job Results directory path configured as a Local Drive?
Part of a cluster, service account configured on SQL server properties.
Job results path configured as a local drive, now I tried to change to another folder, getting this error “Destination directory cannot be created”, and the user is an admin on the server
If you are using the Cluster Client to backup the SQL Server/ Instance (which is recommended so that we can follow the failover events) you would want to make sure that the Job results directory is configured on a Shared Drive that follows that specific SQL Cluster Group during failover.
The cluster configuration should be point to the role\group that contains the target data for the backup. The role\group should have it’s own name IP and disk resources which are configured as it’s own agent in the GUI. The job results should be on the disk resources the role\group contain.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.