Although a SQL instance is skipped, the backup completes successfully with status code 0 reported.

Severity

Data Loss

Description

When backing up all instances of SQL 2012 or higher, the backup will complete with status 0 even if an instance is skipped due to a permission error.

This applies when the policy type of "MS-SQL-Server" is used and the Backup Script contains the Keyword "SQLINSTANCE  $ALL".

The dbclient log shows a permission issue with the instance:
15:19:17.602 [4032.704] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <297>< [Microsoft][SQL Server Native Client 11.0][SQL Server]The user does not have permission to perform this action.>.

However, the backup completes with status 0 (success) reported:
01/12/2017 15:25:13 - Info bphdb (pid=3172) Backup started
01/12/2017 15:25:29 - Info dbclient (pid=6552) DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'sa'.>.
01/12/2017 15:25:29 - Info dbclient (pid=6552) DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.>.
01/12/2017 15:25:29 - Info dbclient (pid=6552) DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'sa'.>.
01/12/2017 15:25:33 - Info dbclient (pid=6552) DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.>.
01/12/2017 15:25:33 - Info dbclient (pid=6552) USER - Unable to login into ODBC DSN <NBMSSQL_6552_5352_4> as user <sa>
.
.
01/12/2017 15:26:17 - Info bpbrm (pid=25626) validating image for client redlight-sql.roguefcu.internal
01/12/2017 15:26:18 - Info bphdb (pid=3172) done. status: 0: the requested operation was successfully completed
01/12/2017 15:26:18 - end writing the requested operation was successfully completed  (0)

Action Required

Hotfixes for NetBackup 8.0 and 7.7.3 are attached to this document.  Please download and apply the appropriate hotfix to the client.

If this issue is experienced on another version of NetBackup, please contact Veritas support, referencing this document and Etrack 3910992 to determine EEB availability.

Resolution:
Veritas Technologies LLC has acknowledged that the above-mentioned issue (Etrack 3910992) is present in the current versions listed under the Products section of this article.  Veritas Technologies LLC is committed to product quality and satisfied customers.

This issue is currently scheduled to be addressed in the next release of NetBackup.  Please be sure to refer back to this document periodically as any changes to the status of the defect will be reflected here.  Use the Subscribe to this Article link to sign up for email notification when this document is updated.

Please note that Veritas Technologies LLC reserves the right to remove any fix from the targeted release if it does not pass quality assurance tests.  Veritas' plans are subject to change and any action taken by you based on the above information or your reliance upon the above information is made at your own risk.

When the next release of NetBackup is available, please access the following link for download and README information:
 https://www.veritas.com/content/support/en_US/15143.html

Hotfix information:
Bug ID: ET 3915497 (8.0) / 3915496 (7.7.3)

Installation Location:  client

Installation Instructions: Please follow the EEB installer instructions available in the linked Related Article.

Checksums (8.0):
2509360980 1225216 AMD64/dbbackmain.dll
3293165415 57344 AMD64/dbbackex.exe


Checksums (7.7.3):
1465667912 1181696 AMD64/dbbackmain.dll
1296684247 56832 AMD64/dbbackex.exe

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)