Troubleshooting
Problem
After changing the SLA for the backup of a Microsoft SQL server in Spectrum Protect Plus, the log backups of this SQL server are failing.
Symptom
The following messages are seen in the Spectrum Protect Plus Joblog:
INFO,1537989132604,Wed 26 Sep 2018 21:12:12 CEST,2,[sqldb.host.name] The last log backup time of database [dbname] is [2018-07-02 23:01:43] INFO,1537989132605,Wed 26 Sep 2018 21:12:12 CEST,2,[sqldb.host.name] The latest log backup of database [INSTANCE\dbname] started at time [2018-07-02 23:01:43] the first trigger time of schedule is [2018/09/20 18:00:00] INFO,1537989132605,Wed 26 Sep 2018 21:12:12 CEST,2,[sqldb.host.name] The latest log backup status [Retry]; message [Executed as user: NT SERVICE\SQLSERVERAGENT. Cannot open backup device '\\192.168.99.82\vpool1_fs80\INSTANCE_dbname\INSTANCE_dbname_LOG_1537466400.trn'. Operating system error 67(The network name cannot be found.). [SQLSTATE 42000] (Error 3201) BACKUP LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013)] for database [INSTANCE\dbname] INFO,1537989132605,Wed 26 Sep 2018 21:12:12 CEST,2,[sqldb.host.name] Preparing to add db [dbname] to backup list INFO,1537989132605,Wed 26 Sep 2018 21:12:12 CEST,2,[sqldb.host.name] Log backup of database [dbname] has been configured
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Component":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB69","label":"Storage TPS"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
19 October 2018
UID
ibm10735651