Hi,
We have purchased a new server and are currently testing upgrading our ADMS from 2010 to 2011. Currently our Vault database in 2010 is at 2.15GB. We did a restore and re-indexed on our new server with ADMS 2011 SP1 and after this completed the database was 3.86GB! I have turned off as may properties as possible and tried a couple of times but still we are at the limit of SQL 2008 express.
Has anyone else seen this?It is a while since we ran a reindex on our current server but only a matter of a couple of months and our Vault has not grown by that much.
I have heard that SP2 is worth trying but we want to be able to access Vault from Inventor 2010 for a while and from what I have read ADMS has to be on SP1 for this to work.
I have raised a call with Autodesk and hopefully we won't have to purchase full SQL but it isn't looking good.
Thanks
Andy
Hi Andrew,
SQL will never automatically shrink the database - it will leave the db files the same size and just consume the available space as-needed. So it is quite possible that the database internally has a lot of room to grow -especially as some data stored during a migration is transient [deleted by the end of migration].
That said, it is possible shrink the database files - however keep in mind that they might need to regrow themselves as your data accumulates. Here's one article on how to do this, I think it can also be done via a sql maintenance plan:
http://technet.microsoft.com/en-us/library/ms189035.aspx
If you shrink the db, I do recommend rebuilding the database indexes - this can be done on each vault from ADMS console. Shrink database is known to fragment the indexes.
Hope this helps,
Paul