cancel
Showing results for 
Search instead for 
Did you mean: 

Activity log showing multiple entries for SQL database backups

Melvin_Paiva
Level 3

Hi All,

I use Netbackup 7.1 to backup databases on one of our SQL servers using the Netbackup SQL agent for SQL server. I have configured SQL based hot backups for this server wich hosts close to 1000 databases (each around 3-4 GB). If I look at the activity log when the backups kick in, I can see one entry for each database. I appreciate this is a feature but getting 1000 entries for 1 backup means its difficult to view the statuses of other backup jobs that run around the same time. Is there any configuration setting that can be changed to suppress the banter and just give me a summary of the backup. I would still need to know which databases have been successfully backed up and which have not.

 

Kind Regards,

Melvin

6 REPLIES 6

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Add BATCHSIZE entry to script to group a number of databases into batches.

See http://www.symantec.com/docs/TECH33423 :

BATCHSIZE is the number of databases NetBackup will attempt to back up simultaneously. If, for example, there are 50 databases on the SQL server, and the BATCHSIZE variable is set to 5, when the backup initiates, the NetBackup SQL extension will grab the first five databases, and start running the backup of those five databases. Depending on the configuration of the media server and the storage units, the backup will use five drives. See the technote "How to back up multiple Microsoft SQL Databases in parallel using more than 1 tape drive" in the Related Documents section below for more information on how to use multiple drives for this type of operation.

In general, if SQL server has only a few large databases, use of stripes will improve performance. If the server has numerous smaller databases, Batchsize will improve performance. Please note it is possible to use both stripes and batchsize at the same time, however, be careful not to overwhelm the system resources.

MKT
Level 5
Employee Accredited

 

BATCHSIZE just determines how many concurrent jobs are running.  Within the legacy GUI's the filtering is limited, however if you install OpsCenter you can review jobs in a Hierarchical View:

 

http://www.symantec.com/business/support/index?page=content&id=DOC5042

 

In the Hierarchical View, all related jobs can be grouped and you can see all

parent-child jobs in a hierarchical fashion. You can view details of only the top

level, parent job in this view with the ability to expand and drill into the details

of child jobs if there are failures.

The HierarchicalView shows details of all jobs and also highlights the parent-child

relationship between jobs wherever applicable. All parent jobs have a +sign before

the job ID. You can click the + sign to see all child jobs. A child job is indented to

the right-hand side in the Job ID column. If some of the child jobs are parent jobs,

Monitoring NetBackup using Symantec OpsCenter

About monitoring NetBackup jobs

424

then + sign also appears before the job ID of the child job. However, if a job does

not have a relationship with any other job (it is neither a parent nor a child job),

it is represented only by its job ID in the Job ID column. Neither is there a + sign

before the job ID of such a job nor this job is indented to the right-hand side.

Melvin_Paiva
Level 3

Hi Marianne,

 

Thank you for responding. From the article, it appears BATCHSIZE will decide how many databases netbackup will backup simultaneously.

I am happy with the speed and performance of the backup of the SQL databases. Just looking for a way to avoid too many entries in the activity log (one for each database when you do a Netbackup SQL backup).

 

Thank you,

 

Melvin

Melvin_Paiva
Level 3

Hi MKT,

 

We do have an Ops center server, however, I will need to fix this within the the activity log.

 

Thank you,

 

Melvin

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

I honestly believe BATCHSIZE is worth a try.

You can also consider GROUPSIZE.

Melvin_Paiva
Level 3

Will try it in the test lab and let you know how it goes.

Thank you,

Melvin