how to purge old data to minimize the DB size ?

Hi all i want to know that is there any facility in Symantec Vontu 11.2 that i can purge data without running script on my database ,basically from Vontu console. Please help.

Hello again,

If you are satisfied with one of the answers, can you mark that as solution? This way, others know where to look for answers, and people will not open the question to provide an answer.....

Thanks, and good luck!

The beauty of a lab:

 

https://www-secure.symantec.com/connect/articles/6-reasons-why-everyone-should-have-enterprise-vault-lab

Thank you All ......hope i can repeat the same steps while performing in production without any flaws.

Here is a starting point:

 

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

Thanks for the reply. Sorry the EV is 10 . I wanted to purge data of auditing and monitoring ....by keeping data of only 90days . My database contains data of last 1.5 years. can i perform purging activity manually on the database server ? what are the basics steps to perform the activity on the oracle server can any share please.

Which databases are you talking about? Audit? Monitoring? Directory? Vault store? Fingerprint? Discovery Accelerator customer databases? Auditing and monitoring you can set how many days worth of records to keep Directory shouldn't be all that big even in large environments Vault store and fingerprint databases will keep records for all live EV data and with the use of DA can grow large when applying large amounts of legal holds But those databases will only remove records when you delete archives, when a user deletes items or when you perform storage expiry Typically though deleting old archives and using storage expiry should be something that the legal team would determine in order to meet their own compliance needs So for instance if you have the need to keep every item forever then there is nothing you can do except to plan for the databases to get bigger as that is there need and you have to work that in to your plans Also some people will mistake large transaction logs for being large databases, in which case make sure your maintenance schedule is set to truncate the transaction logs after every database backup If you don't do this then the transaction log will grow and grow and usually be bigger than the actual database files

Hello,

I assume you have Enterprise Vault 10. As far as I know, EV11 is not available (yet).

There is an extensive technote on SQL maintenance for EV databases. Check this: http://www.symantec.com/docs/TECH74666

In addition, you do NOT purge data from EV databases. The only TABLE I know can be purged (to be recreated by provisioning) is the ExchangeMailboxEntry table in the Directory database. The remaining databases will be maintained using the above mentioned document. If you configure Enterprise Vault to do (for instance) storage expiry on archived items, EV will take care of removing entries from the databases affected. When that is done during normal business, your maintenance plan will take care of managing the databases.

You can do some housekeeping on the monitoring database (http://www.symantec.com/docs/TECH72170) and the audit database (if auditing is enabled) (document to be found.... )

If this does not answer your question, can you be more specific in what you see, want, and expect?

I don't think you have EV 11... maybe 10?

You can ...

a/ delete items manually, or using search.asp, and add them to a basket then delete the items

b/ set a low retention category period on them, and then use storage expiry

 

They're just a few options.