cancel
Showing results for 
Search instead for 
Did you mean: 

FAILED: SQL 2008 backup with Status Code: 2

siddharth_khata
Level 3

Hi,

- Netbackup Master server 7.0 running on RHEL 6.23.- Stand-Alone system

- SQL 2008 Enterprise Server running on Windows 2008 R2 (64 bit)

Here it is my backup script:

OPERATION BACKUP
DATABASE "TestDatabase"
SQLHOST "tsm-vm15"
NBSERVER "PTS00235"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
 
Plese find the attached dbclient log file.
 

Note:

I've tried using local Administrator account to run on the NetBackup Client Service.

MS-Windows filesystem backup working successfully.

 

1 ACCEPTED SOLUTION

Accepted Solutions

sri_vani
Level 6
Partner

If the database remains in a loading state please verify this link:

http://www.symantec.com/business/support/index?page=content&id=TECH45390

 

If the database is in a loading state and needs to be restarted, log into the Microsoft SQL Query Analyzer and run the following command, entering the name of the database in place of <database_name>:

restore database <database_name> with recovery

This command restarts the SQL database and takes it out of a loading state.

View solution in original post

3 REPLIES 3

siddharth_khata
Level 3

Would appreciate if anyone can assist or give pointers to where to look to correct the problem.

Thanks!

Mark_Solutions
Level 6
Partner Accredited Certified

The log says this:

16:20:05.036 [4900.4884] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <927><[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'TestDatabase' cannot be opened. It is in the middle of a restore.>.

This indicates that there is an issue with that database

When running backups against SQL 2008 you should have the NetBackup Client Service and NetBackup Legacy Network Service both running as an account that has dbadmin rights on all SQL databases

But you need to check the database first - perhaps try backing up another database as well to see if it works in general while you have the dba checkout that database

Hope this helps

#edit#

Also this later at the end of the log file:

16:38:10.104 [4992.4216] <16> Dbbackrec::PerformNBOperation: USER - Operation inhibited by NetBackup for Microsoft SQL Server: Database <TestDatabase> cannot be backed up because it is in <loading> state.

 

sri_vani
Level 6
Partner

If the database remains in a loading state please verify this link:

http://www.symantec.com/business/support/index?page=content&id=TECH45390

 

If the database is in a loading state and needs to be restarted, log into the Microsoft SQL Query Analyzer and run the following command, entering the name of the database in place of <database_name>:

restore database <database_name> with recovery

This command restarts the SQL database and takes it out of a loading state.