09-16-2015 07:35 AM
Hi All,
we see SQL transaction log backup completing with status code 1 with below error:
09/16/2015 09:18:58 - Info dbclient (pid=6000) USER - Operation inhibited by NetBackup for Microsoft SQL Server: Database <XXX_YYY_Webview> cannot be backed up because it is in <offline> state.
09/16/2015 09:18:59 - Info dbclient (pid=6000) INF - OPERATION #3 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\TVS_SQL_Logs.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 4(4) seconds.
Its working fine for rest of the DB tx log backup from the same job.
Please help.
Solved! Go to Solution.
09-16-2015 07:48 AM
Database <XXX_YYY_Webview> cannot be backed up because it is in <offline> state
If the database is not required to be backed up then amend or exclude from your sql .bch script.
If it is required to be backed up then it needs to be brought online.
09-16-2015 07:48 AM
Database <XXX_YYY_Webview> cannot be backed up because it is in <offline> state
If the database is not required to be backed up then amend or exclude from your sql .bch script.
If it is required to be backed up then it needs to be brought online.
09-16-2015 08:49 AM
Thanks for the information Andy.
I'm just curious to know wheather NBU supports cold backup of SQL DBs / its transactional logs.
09-17-2015 12:26 AM
I'm just curious to know wheather NBU supports cold backup of SQL DBs / its transactional logs.
If the database is offline, you could backup the database files (*.mdf, *.ndf) and log file (*.ldf) for the database in question using a 'normal' MS-WindowsNT policy.