cancel
Showing results for 
Search instead for 
Did you mean: 

Using GROUPSIZE for SQL Server

riazjee
Level 4

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 Server>"
SQLINSTANCE "<Instance>"
NBSERVER "<NB Master>"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "RiazTest2"
SQLHOST "<DB Server>"
SQLINSTANCE "<Instance>"
NBSERVER "<NB Master>"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE
OPERATION BACKUP
DATABASE "RiazTest3"
SQLHOST "<DB Server>"
SQLINSTANCE "<Instance>"
NBSERVER "<NB Master>"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

I am attaching the NB console output.

Environment:

NB Master: 8.0

OS: Windows 2008 R2

Client: 8.0

Client OS: Windows 2008 R2

SQL Server: 2012 SP3

I've even tried with database $ALL option without any success.

Can you please guide me how to correctly use GROUPSIZE?

 

Thanks

24 REPLIES 24

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

SLP duplication and replication has nothing to do with number of images, but rather size of images. 

Images are batched into duplication/replication 'chunks' when MIN_KB_SIZE_PER_DUPLICATION_JOB is reached. The default is 8 GB.

Herewith TNs with parameters that can be tuned. 
The 2nd link is for tape, but still worth a read. 

https://www.veritas.com/support/en_US/article.100021613

https://www.veritas.com/support/en_US/article.100014136

 

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

as above stated, just click Perform Snapshot Backup in the policy (nothing special is needed, on Windows 2008 by default VSS will be used for that).

If the server is VMware VM, you can use VMware based policy for DB backups - then VM including all the databases are in one backup image.

These backups are also better deduplicated than traditional sql backups, so less data is transfered during replication.

Regards

Hello Michal_Mikulik1,

I will have to study more about snapshot backup beofre I can implement it for prouction environment. But does the snapshot backup groups multiple databases as one netbackup ID/ storage image or not?

Regards,

 

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

you ask the same question over and over. Everything you need is in the previous posts. The topic is also pretty documented in SQL Admin Guide. Since the thread opening, you could have also tested this config x times in your env.

Regards,

 

My apologies If you felt so; although that was not intention.

Anyways I will go ahead and close this thread. I've already taken the issue with the veritas and they are checking the overall system heal plus various configurations.

Thanks all for your help.