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

Opscenter : report on data growth on backup with accelarator option enabled.

 

Hi,

 

i have this file server(terabytes of data) backed up with accelerator turned on.

i want to calculate the data growth, but not possible to get the exact size of data backed up since the accelerator is enabled.

the report will produce an output as below:

full backup.PNG

data on May was the last full backup before we enable accelerator.

any idea how to get the exact size of the actual full backup?

1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

You can run a sql query, the

You can run a sql query, the result will just be a table, not a graph. You can try

select
COALESCE(CAST(SUM(domain_JobArchive.bytesWritten)/1024.0/1024.0/1024.0 AS NUMERIC (20,2)), 0) AS 'Written (GB)',

COALESCE(CAST(SUM(domain_JobArchive.PreSISSize)/1024.0/1024.0/1024.0 AS NUMERIC (20,2)), 0) AS 'Protected (GB)',
domain_JobArchive.ClientName as "Client",
DATEFORMAT(cast(UTCBigintToNOMTime(domain_JobArchive.endTime) as DATETIME), 'yyyy-mm-dd') as "Date"
FROM domain_JobArchive
WHERE
DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 30
AND
domain_JobArchive.type in (0)
AND
domain_JobArchive.clientname like '%CASE SENSITIVE CLIENT NAME%'
group by "Client", "Date" order by "Date"

View solution in original post

6 Replies
Highlighted

Not sure which reports you're

Not sure which reports you're running. In OpsCenter Database it records to values, kbytes and what is called presissize. Kbytes is what is stored after deduplication, presissize is the actual size of the backup. Many reports use Kbytes and the results are therefore not accurate in terms of what you thought you'd see.

 

You could either create your own custom report or use an SQL query to get the figures you're looking for.

 

P.S This only applies if you're using MSDP/Appliance, not with other deduplication OST vendors.

Highlighted

Hi Riaan, i took the backup

 

Hi Riaan,

i took the backup with accelerator enable.

so not all files were being backed up or transfered for the full backup with this option enabled.

From the graph attached(i select report template>backup report>Job Activity Reports>Job Size), the first time full backup showing the whole size of data backed up and the full backup after that, only files that have been changed were transfered.

 

Is there any report template to show the specific client full backup actual size?

 

Pleae advise.

Highlighted
Accepted Solution!

You can run a sql query, the

You can run a sql query, the result will just be a table, not a graph. You can try

select
COALESCE(CAST(SUM(domain_JobArchive.bytesWritten)/1024.0/1024.0/1024.0 AS NUMERIC (20,2)), 0) AS 'Written (GB)',

COALESCE(CAST(SUM(domain_JobArchive.PreSISSize)/1024.0/1024.0/1024.0 AS NUMERIC (20,2)), 0) AS 'Protected (GB)',
domain_JobArchive.ClientName as "Client",
DATEFORMAT(cast(UTCBigintToNOMTime(domain_JobArchive.endTime) as DATETIME), 'yyyy-mm-dd') as "Date"
FROM domain_JobArchive
WHERE
DATEDIFF(day,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 30
AND
domain_JobArchive.type in (0)
AND
domain_JobArchive.clientname like '%CASE SENSITIVE CLIENT NAME%'
group by "Client", "Date" order by "Date"

View solution in original post

Highlighted

Hi Riaan, thanks for the

 

Hi Riaan,

 

thanks for the query.

what is the different between written and protected?

 

Cheers

 

Aris.

Highlighted

When you're using

When you're using MSDP/Appliance you'll have two figures. The "protected" or PreSISsize is what is really on the client, and the figure you'll see in the Kbytes column of the activity monitor. The Kbytes written is what is actually stored by the deduplication storage server (The first backup would be the full set of data, but subsequent data sets would only by block/segment level changes).

Highlighted

Hi Riaan, thanks for the

 

Hi Riaan,

thanks for the explanation.

cheers,

 

aris.