cancel
Showing results for 
Search instead for 
Did you mean: 

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

balrchin
Level 2

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@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 4

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@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).

L_BR
Level 5

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.

Hi Mariene,

 

I have uploaded the dbclient logs , please verify them and let me the further step to resolve the issue.

 

Thanks-Bala

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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.