12-03-2013 06:10 AM
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:
Note:
I've tried using local Administrator account to run on the NetBackup Client Service.
MS-Windows filesystem backup working successfully.
Solved! Go to Solution.
12-03-2013 08:09 AM
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.
12-03-2013 06:11 AM
Would appreciate if anyone can assist or give pointers to where to look to correct the problem.
Thanks!
12-03-2013 06:46 AM
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.
12-03-2013 08:09 AM
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.