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

Re: Using GROUPSIZE for SQL Server

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

 

Re: Using GROUPSIZE for SQL Server

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

Highlighted

Re: Using GROUPSIZE for SQL Server

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,

 
Highlighted

Re: Using GROUPSIZE for SQL Server

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,

 

Highlighted

Re: Using GROUPSIZE for SQL Server

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.