cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Transaction log backup completing with status code 1

Bharath_Achar
Level 6

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Andy_Welburn
Level 6

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.

View solution in original post

3 REPLIES 3

Andy_Welburn
Level 6

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.

Bharath_Achar
Level 6

Thanks for the information Andy.

I'm just curious to know wheather NBU supports cold backup of SQL DBs / its transactional logs. 

 

Andy_Welburn
Level 6

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.