Failed obliterate operation.

far9999 · Post by **far9999** » Thu Mar 22, 2007 2:25 pm

In the middle of an obliterate operation, our sourcegear admin client threw out an error and appeared to stop working. We were obliterating about 2gb worth of files. When we went to check the database, it had changed very little in size (e.g. using sp_spaceused in sqlcmd) but the admin client no longer listed the directory we wanted to obliterate.

How do we get rid of these files if they aren't listed in obliterate panel anymore?

We are using SQL Server 2005 Express and Vault 3.1.9.

Any help is greatly appreciated!

Thanks.

Beth · Post by **Beth** » Thu Mar 22, 2007 3:41 pm

A obliterate doesn't make the database smaller. It will remove the items necessary so that a shrink database can make it smaller. Here's some info on the shrink database SQL command: http://msdn2.microsoft.com/en-us/library/ms141819.aspx.

You will probably want to also check out our article on database maintenance: http://support.sourcegear.com/viewtopic.php?t=2924

and check on your logs to see if they need truncating if you need the extra space: http://support.sourcegear.com/viewtopic.php?p=29431

far9999 · Post by **far9999** » Thu Mar 22, 2007 3:48 pm

I understand the file size of the database will not change, but the space available in the database (e.g. through sp_spaceused) has not changed. When I deleted smaller items the available space was changed.

I did run dbcc shrinkdatabase() and it complains there isn't enough space.

Beth · Post by **Beth** » Fri Mar 23, 2007 1:20 pm

Can you restart your Vault server and then take a look at it again?

Do you see any errors in your Vault Server Log around that same time?

How much disk space do you have open for your server to perform operations?