Video Screencast Help

FAILED: SQL 2008 backup with Status Code: 2

Created: 03 Dec 2013 • Updated: 03 Dec 2013 | 3 comments
This issue has been solved. See solution.

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.

 

Operating Systems:

Comments 3 CommentsJump to latest comment

siddharth_khatavkar's picture

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

Thanks!

Mark_Solutions's picture

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.

 

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.

sri vani's picture

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

http://www.symantec.com/business/support/index?pag...

 

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.

SOLUTION