Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

Enterprise Vault directory DB

Updated: 21 May 2010 | 7 comments
Richard ware's picture
0 0 Votes
Login to vote
This issue has been solved. See solution.
Just checked the size of the mdf on the sql server and its 154 Gb yes Gb large is the usual....
Discussion Filed Under:

Comments

Rob Hanson's picture
27
Apr
2007
0 Votes 0
Login to vote

This is very unusual, it is normally quite a small database, normally in the 50 - 120 MB range.
 
Are you sure that you are not confusing the VaultDev10.mdf (the actual database) with the VaultLog10.mdf file which is in fact the Transaction log file.  Yes they both have the same extension.
TonySterling's picture
27
Apr
2007
0 Votes 0
Login to vote

Rob is right, they have the same extension.  Check the properties of it using Enterprise Manager.

Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK

symsks's picture
22
Oct
2009
0 Votes 0
Login to vote

I have a file

I have a file "vaultlogcf.mdf" that has grown to 5GB.  It was 3GB yesterday and the system has only archived 300MB overnight ... any way to shrink this?

Scanner001's picture
22
Oct
2009
0 Votes 0
Login to vote

You can do a shrink through

You can do a shrink through SQL Management studio

OPen SQL management Studio
Select your database
Right Click on the database
Navigate to Tasks
Navigate to Shrink
Navigate to database

DO NOT CLICK on the Reorganize tick boox as it will take a long time for this to run

Click OK and this will shrink the databse

Next repeat the process but this time select files
Then click on Release unused space

You have to repeat again for files but second time select LOG as file type instead of Data

Ideally you should set this up as a weekly maintainance job to defrag, reindex and compress each database

Liam Finn
 

symsks's picture
22
Oct
2009
0 Votes 0
Login to vote

thanks, but that only shrunk

thanks, but that only shrunk the 'vaultlogcf.mdf' file by 100MB out of 5GB when I did the shrink database. Once I did shrink files/logs (sql 2005) -- the mdf file went back up to 5.1GB.  I've repeated the shrink database and the same result of only 100MB smaller out of 5GB.

Is this 'vaultlogcf.mdf' storing all the historical data of when i was testing the archiving for this mailbox (I archived 5GB then exported it out to PST/mailbox and deleted what was in the vault/archive)?  

My enterprise vault currently only has 300-500MB of archived mail in it ... I don't feel the vaultlog.cff should be anywhere near this size ...

Scanner001's picture
22
Oct
2009
0 Votes 0
Login to vote

It does seem excessively

It does seem excessively large because my archive is 40TB and my database and log are 9 and 7GB respectively

Liam Finn
 

TonySterling's picture
22
Oct
2009
0 Votes 0
Login to vote

The log file is keeping track

The log file is keeping track of all the changes in SQL.  What is your SQL recovery model?

Also, it is better to post your query in a new thread instead of resurrecting one over 2 years old, that way if someone give you your answer you can mark the post as solved and give them credit.  Could you start a new thread for this?

Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK