Video Screencast Help

Calculating monthly total backup

Created: 12 Nov 2013 • Updated: 14 Nov 2013 | 11 comments
This issue has been solved. See solution.

Hi,

New to Netbackup and netbackup community.

I'm looking for some help on calculating the total amount of data being backup per Month, in order to estimate capacity license.

I run multiple agents like:Windows filebackup, Oracle, SQL, VMs

Some of my backup policies are incremental, differential and fulls; which are weekly and monthly full.

I have exported a months worth of data from the activity monitor, this export includes incremental, differential, and full information.

The problem I'm having is some of the jobs like the SQL jobs have a (job schedule) that is full_onsite,Default Application, SQL - application and full, I'm not quite sure if I should be adding all of these backup into the monthly totals.

Also is there a tool that I can run that would give me a Monthly totals?

Thanks

 

    

Operating Systems:

Comments 11 CommentsJump to latest comment

quebek's picture

Hello

Please read about the nbdeployutil command. This command help you with the issue you are facing...

Link to admin guide for commands is at:

http://www.symantec.com/docs/DOC5182

Quote:

"nbdeployutil – deployment utility that gathers and analyzes master server
information regarding clients and capacity"

"On UNIX and Linux systems, the directory path to this command is
/usr/openv/netbackup/bin/admincmd/
On Windows systems, the directory path to this command is
<install_path>\NetBackup\bin\admincmd\"

"DESCRIPTION
The nbdeployutil utility gathers and analyzes deployment information from the master server. The utility performs a deployment analysis according to one of two NetBackup licensing models, either Traditional  licensing or Capacity Licensing. A Traditional Licensing deployment analysis counts the number of clients and servers then compares this information against licensed options. Capacity Licensing deployment analysis calculates how much source data is protected.
The command is run in two steps. nbdeployutil gathers the data in the first step and analyzes the data in the second step.
The utility generates a log file named nbdeployutil-gather-timestamp.log during the gathering operation. The utility generates a log file named nbdeployutil-report-timestamp.log during the analysis and the report
generating operation. By default the log files are created in the directory where the gathered data resides."
 

Ah45's picture

Hi,

And From Opscenter also you can extract total montly backup Report,

If you need any help, please let me know, I can proivde the steps..

 

 

Durodup's picture

Hi Ah45,

I would greatly appreciate you help,

I looking at the OPScenter report templates but I do not see one for monthly data, If I create a report would I be using the template under "Backup Window" job size?

 

Mark_Solutions's picture

OpsCenter gives a total of the data backed up but does not represent a figure for Front End TB

You need to use the nbdeployutil to do that and then analyse the output carefully to check and overlap

Otherwise you need to just run an analysis on all of your servers to see what their used disk space is which gives you an idea FE TB figure

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.

Durodup's picture

IThanks,

I only need to know the total amount of data being backup, how much data we backup per month, as indicated I have exported a month worth of data from our netbackup activity monitor, I'm just not sure if I should add up only the full backups or do i need to add the application full. fullonsite or incremental etc... 

Ah45's picture

Durodup,

what kind of Opscenter license you have,

opscenter analytics???

Durodup's picture

No we are too cheap to have analytic, just the plain out of the box Opscenter

 

Mark_Solutions's picture

You initially said you need this to calculate for a capacity license and that is what the nbdeployutil does for you - it creates everything in a spread sheet for you and shows what capacity license you need.

If you want to do it manually just go to the Admin Console - NetBackup Management - Reports - Client Backups and run the report in there for a weekend or when ever you did a full weekly / monthly backup run.

Then File - Export, save it to a text file and open excel and point to the text file

It should load it straight in - sum column F - then point to that sum selection using a simple formula (assuming you sum in this example is in box F123) of =F123/1024/1024/1024 and you get you full backup TB figure

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.

Ah45's picture

then we cannot create custom reports and neither right sql query..

plz check with existing reports, that may be helpfull

Durodup's picture

Thank you all for your help,

I have decided to run the nbdeployutil for the required information

 

SOLUTION
Ah45's picture

Please mark as solution the comment which helped, instead of marking yourself

from above

i can see that

quebek wrote

"Hello

Please read about the nbdeployutil command. This command help you with the issue you are facing...

Link to admin guide for commands is at:

http://www.symantec.com/docs/DOC5182

Quote:

"nbdeployutil – deployment utility that gathers and analyzes master server
information regarding clients and capacity"

"On UNIX and Linux systems, the directory path to this command is
/usr/openv/netbackup/bin/admincmd/
On Windows systems, the directory path to this command is
<install_path>\NetBackup\bin\admincmd\"

"