Shulou(Shulou.com)05/31 Report--

This article focuses on "analyzing the error code of SqlServer NBU backup". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Now let the editor to take you to learn "analyze the error code of SqlServer NBU backup"!

The shutdown of the SQL Server instance caused an error code for NBU backup

A few days ago, a set of SqlServer databases using NBU backup system suddenly failed to back up, so simply record the process.

Step 1: view detail information

Log in to the NBU console and click the error report JOB to view the Detail and find the following error message:

20XX-XX-XX XX:XX:05-Error bpbrm (pid=257338) from client XXXX: ERR-command failed: none of the requested files were backed up (2) 20XX-XX-XX XX:XX:05-Error bpbrm (pid=257338) from client XXXX: ERR-bphdb exit status = 2: none of the requested files were backed up20XX-XX-XX XX:XX:06-Info bphdb (pid=2828) done. Status: 2: none of the requested files were backed up20XX-XX-XX XX:XX:06-end writingnone of the requested files were backed up (2) step 2: view the backup log

Error code 2 indicates that any file in the file list was not backed up by the backup operation. The official document is described as follows:

NetBackup status code: 2

Message: none of the requested files have been backed up

Description: the backup or archiving operation did not back up any files in the file list.

This status code mainly occurs when all backups related to the job fail when using the Lotus Notes or SQL Server database agent for automatic backups. Alternatively, the Enterprise Vault backup has failed. This status code does not appear during a standard file system backup.

"if you encounter this error while backing up a UNIX, Linux, or Windows file system, or if it occurs in a database agent other than SQL Server or Lotus Notes, open the NetBackup support case recommended in Technical Note TECH38838)." Recommended action: do the following as needed:

■ the following information applies to Lotus Notes only.

Occurs on UNIX if archived logging is not enabled for Lotus Domino Server

This error. This error also occurs if another backup operation is being performed on the transaction log.

For more information about ■ troubleshooting instructions (for example, a list of logs to be collected) and specific issues, please

Refer to the technical note TECH38838.

For ■ 's description of troubleshooting tools, see the troubleshooting topics in the appropriate guidelines below:

■ NetBackup for Microsoft SQL Server Administration Guide

■ NetBackup for Lotus Notes Administration Guide

Log in to the SqlServer database server and view the NBU backup log

The specific path is

\ logs\ user_ops\ mssql\ logs

Open the log file for the error period, indicating that the database instance cannot be accessed

DBMS MSG-ODBC return code, SQL State, SQL Message. DBMS MSG-SQL Message DBMS MSG-SQL Message DBMS MSG-ODBC return code, SQL State, SQL Message. Step 3: view database instance status

Log in to the database server and find that the database service is stopped. Backup succeeded after reboot

Check method: computer Management-> Services and applications-> SQL Server configuration Manager-> SQL Server Services.

At this point, I believe that everyone on the "analysis of SqlServer NBU backup error code" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.