Forum Discussion

riazjee's avatar
riazjee
Level 4
7 years ago

Using GROUPSIZE for SQL Server

Dear All, I am trying to use GROUPSIZE parameter but it seems NB is ignoring the parameters. Below are the Script file contents: GROUPSIZE 3 OPERATION BACKUP DATABASE "RiazTest1" SQLHOST "<DB Se...
8
Windows Server 2008 R2
  • Marianne's avatar
    Marianne
    7 years ago

    This is weird - have a look at this entry at the beginning of the backup:

    14:50:52.531 [6568.8332] <4> CDBbackmain:: OperationsAreGroupable: INF - The batch file is not groupable because a standard policy type has been selected for backup.

    EDIT: 

    I think this entry in the manual is key :

    The method for aggregating database Snapshot Client backups is called backup "grouping".

    So - only supported for Snapshot Client policies? 

Michal_Mikulik1's avatar
Michal_Mikulik1
Moderator

Hello,

it is only terminology play. You should have, for example:

<DB Server>_1531256478 (1 NetBackup "image") with 3 "files" in it:

<DB Server>.MSSQL7.<DB Server>\<Instance>.db.RiazTest1.~.7.001of001.20180515115807..C

<DB Server>.MSSQL7.<DB Server>\<Instance>.db.RiazTest2.~.7.001of001.20180515115902..C

<DB Server>.MSSQL7.<DB Server>\<Instance>.db.RiazTest3.~.7.001of001.20180515115951..C

Regards

Michal

riazjee's avatar
riazjee
Level 4
7 years ago

Thanks for the reply.

So there should be one backup ID shown in the catalog for the grouped databases' backup?