Forum Discussion

Aris56's avatar
Aris56
Level 4
9 years ago

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 sinc...
Agents
Backing Up
Backup and Recovery
Case Study
Configuring
Documentation
Monitoring
OpsCenter
Tip-How to
Windows Server (2003-2008)
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    9 years ago

    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"

RiaanBadenhorst's avatar
RiaanBadenhorst
Level 6
9 years ago

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.