Forum Discussion

James_Slack's avatar
James_Slack
Level 6
12 years ago
Solved

Vault items "Awaiting Backup" not cleairing down

Hi,

There is a web page I use to monitor items awaiting backup, the Vault Store Usage Reporter.

This is indicating we are now up to 6 million items awaiting backup - and growing!

We use the trigger file method, as out current backup solution doesn't work correctly with Vault to reset the Archive Bits.

I have a script in place I manually run, it deletes all the old archive trigger files and creates new ones. But something is not right, it doesn't clear down any more.

I checked that all partitions are looking for the trigger bit and the file is going to the correct location... all looks right to me and this has been working fine for over a year.

When I first started looking at this, I stumbled across a table in SQL that was a list of all the items awaiting backup, so I could see which partition was having backup issues. I can't find this now.

Can anyone please tell me which table I need to look at, or maybe it was a query.

I need to work out which items are not getting maked as backed up.

Thanks

James

 

 

Backing Up
Enterprise Vault
Information Governance
Monitoring
Windows Server (2003-2008)
  • GabeV's avatar
    GabeV
    12 years ago

    James,

    Take a look at this technote:

    SQL Index Fragmentation and Statistics
    http://www.symantec.com/docs/TECH168905

    Basically, you need to run the following SQL query:

    DBCC SHOWCONTIG WITH ALL_INDEXES

    The technote above has more details of what you need to look for in the output. Keep in mind that if you have high fragmentation, you need to run a SQL maintenance to fix it. That will improve the EV performance. If that's the case (i.e. there is high fragmentation in SQL) , you need to read this technote:

    How to automatically back up and perform recommended maintenance for Enterprise Vault SQL databases
    http://www.symantec.com/docs/TECH74666

    Forward it to the team that is in charge of the SQL server maintenance to confirm if they are following the correct steps.

  • GabeV's avatar
    GabeV
    Level 6
    12 years ago

    James,

    Take a look at this technote:

    SQL Index Fragmentation and Statistics
    http://www.symantec.com/docs/TECH168905

    Basically, you need to run the following SQL query:

    DBCC SHOWCONTIG WITH ALL_INDEXES

    The technote above has more details of what you need to look for in the output. Keep in mind that if you have high fragmentation, you need to run a SQL maintenance to fix it. That will improve the EV performance. If that's the case (i.e. there is high fragmentation in SQL) , you need to read this technote:

    How to automatically back up and perform recommended maintenance for Enterprise Vault SQL databases
    http://www.symantec.com/docs/TECH74666

    Forward it to the team that is in charge of the SQL server maintenance to confirm if they are following the correct steps.

  • James_Slack's avatar
    James_Slack
    Level 6
    12 years ago

    Ah, is the table I was thinking of DBO.Watchfile?

    Is there a way to query this for ItemSecured = no, or something?

  • James_Slack's avatar
    James_Slack
    Level 6
    12 years ago

    Think this is it: SELECT * FROM [EVMailboxVaultStore].[dbo].[WatchFile] where ItemSecured = 0

    Running now, will see how many I get.

    Will look at SQL health in a minute!

    Thank you

  • James_Slack's avatar
    James_Slack
    Level 6
    12 years ago

    Eventually this just worked, needed to redo the delete and create of .txt / .old about 8 times to clear all 6mil files. Had actually changed nothing, but used my above SQL to detirmine the stores causing the issues and confirmed they were all fine.

    I suspect this was ultimately down to performance due to the SQL side of things and will make that as solution. Though I expect that it will ultimately be a can of worms, now open.

    Thanks both for your help, sorry I can't make you both as the solution.