Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Clean up Vault 8 Database and start from scratch

Updated: 21 May 2010 | 2 comments
Dave Tammi's picture
0 0 Votes
Login to vote
This issue has been solved. See solution.

Hi,

We have upgraded to Vault 8 from Vault 2007. We were testing, but never completed the implementation of Vault 2007.

I currently have no users or test accounts in the new vault, but the "Exchange Mailbox Archiving Status" report still shows all the users that we provisioned in the past. They all have the correct status of "disabled" or "Never enabled", but I want to clean out the database to an "out-of-the-box" state with nobody in it.

The Vault Store and Vault Index folders are empty.

It looks like the old info is coming from the dbo.ExchangeMailboxEntry table.

Can I simply delete these records to get back to a clean state?

Thanks in advance for any help.

Dave

Comments

JesusWept's picture
02
Nov
2009
0 Votes 0
Login to vote

The ExchangeMailboxEntry

The ExchangeMailboxEntry table is generated from the Provisioning task, you can do a truncate or delete statement against that table and next time provisioning runs, it will re-populate, and it will bring across everyone especially if you are targeting a domain using Whole Exchange Organization

The only time you cannot truncate a table fully is if a journal mailbox that is being targeted resides in there.
you would need to delete everything that isnt the journal mailbox, or delete the target through the vac, delete the contents of the EME table and re-add the journal mailbox as a target

PJuster's picture
02
Nov
2009
0 Votes 0
Login to vote

Hi, JesusWept is correct you

Hi,

JesusWept is correct you can delete the contents of the exchangemailboxentry table.  But why not delete all the EV SQL databases, uninstall EV 8.0 and reinstall.  This will truely be an out of the box as it will be a fresh install.

Don't forget to empty your index, shopping and vault store partitions, or use new ones.