cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

STATUS CODE 2: Microsoft SQL backups fail with a NetBackup Status Code 2 "none of the requested file

Could some one help me resolving this issue -

 

It was backing up till yesterday and its failing since one day

(2) none of the requested files were backed up.

 

I have attached the detailed status of the job.

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

Re: STATUS CODE 2: Microsoft SQL backups fail with a NetBackup Status Code 2 "none of the reque

@balrchin

You need to find out what has changed on the SQL client.

Has anyone perhaps modified the script?

Please see if there is a GROUPSIZE entry in the script:

Feb 12, 2018 11:47:53 AM - Info dbclient (pid=8948) USER - GROUPSIZE must be between 1 and 32.
Feb 12, 2018 11:47:55 AM - Info dbclient (pid=8948) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\FullBackupDAG.bch>:

If this is not the issue, ensure dbclient log foilder exists on the client (under ...NetBackup\logs) and retry the backup.

Check dbclient log for errors (or upload as dbclient.txt).

View solution in original post

4 Replies
Highlighted
Accepted Solution!

Re: STATUS CODE 2: Microsoft SQL backups fail with a NetBackup Status Code 2 "none of the reque

@balrchin

You need to find out what has changed on the SQL client.

Has anyone perhaps modified the script?

Please see if there is a GROUPSIZE entry in the script:

Feb 12, 2018 11:47:53 AM - Info dbclient (pid=8948) USER - GROUPSIZE must be between 1 and 32.
Feb 12, 2018 11:47:55 AM - Info dbclient (pid=8948) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\FullBackupDAG.bch>:

If this is not the issue, ensure dbclient log foilder exists on the client (under ...NetBackup\logs) and retry the backup.

Check dbclient log for errors (or upload as dbclient.txt).

View solution in original post

Highlighted

Re: STATUS CODE 2: Microsoft SQL backups fail with a NetBackup Status Code 2 "none of the reque

Try the solution from here:https://vox.veritas.com/t5/NetBackup/SQL-Agent-GROUPSIZE-issue/td-p/424413

In the Detailed status you have the following error: 

 

12, 2018 11:47:53 AM - Info dbclient (pid=8948) USER - GROUPSIZE must be between 1 and 32.

Highlighted

Re: STATUS CODE 2: Microsoft SQL backups fail with a NetBackup Status Code 2 "none of the reque

Highlighted

Re: STATUS CODE 2: Microsoft SQL backups fail with a NetBackup Status Code 2 "none of the reque

I am confused about the fact that you marked the post as solved.
Did you check the script? 
Can you please upload it here?

There is definitely a problem with the script as we see the following in the log:  

CDBbackmain:: OperationsAreGroupable: INF - The batch file is not groupable because the master database is included in the grouping set.
.....
ReadBatch: USER - GROUPSIZE must be between 1 and 32.

Oh! There seems to be 2 separate scripts - the log for 10 Feb shows this script name: 
C:\Program Files\Veritas\NetBackup\DbExt\MsSql\FullBackupPhysical.bch
and seems to indicate successful backup.

The failure on 11 Feb shows this script name:
C:\Program Files\Veritas\NetBackup\DbExt\MsSql\FullBackupDAG.bch 

You need to check FullBackupDAG.bch. 
Compare with FullBackupPhysical.bch to see what is different.