I have had the problem with the *mdf file being too large in the past. When my users were having problems yesterday I thought the solution would just be too purge and move on (this is after I reset the server clock to match machine clocks). I did the purge and got some error.
I have read others having this same problem and tried some of the steps to solve the problem:
1. Tried to reattach - Vault already exists (of course).
2. Tried to rename mdf file to newvault and changed the filestore location - error - I think due to the mdf file size.
From the workstation, the vault appears to be there but when you try and log in, it does not exist.
I tried making a new vault to try and preserve what I have locally - no luck - same error messages.
Anyone have any ideas? Somehow, I need to shrink the size of the mdf file so my vault will be happy again.
Server: Windows 2000 SP3, Vault 4
Workstation: 2 Dual Core Opterons 1.8GHZ, 2 Quadro FX3400 in SLI, 4 GB RAM, Inventor 10, Vault 4