What are the challenges you face when working across database platforms? Take the survey

/compactdb - file is in use by another process

jfleisherjfleisher Posts: 5
edited July 25, 2013 3:33PM in SmartAssembly
Searched and found no posts concerning /compactdb. Surprising since I can't get this option to work on either machine that I've tried. Must be missing something that is needed to make it work.
C:\Program Files\Red Gate\SmartAssembly 6>SmartAssembly.com /compactdb
SmartAssembly v6.8.0.121
Copyright c Red Gate Software 2005-2013

System.IO.IOException : The process cannot access the file because it is being used by another process.

I've tried everything I know to find a process using database.mdb or .ldb but so far I'm unsuccessful at running the /compactdb command on two separate machines that I've tried. One is a developer machine and the other is a production build server.

Using Process Explorer (Run as Admin), I can't see any process that is using database.mdb. I have rebooted the machine. I have ran the smartassembly GUI and found the file in use at that point, but exiting the GUI frees the handle to that file.

Is it possible to successfully use /compactdb and how can it be done? The OS levels are WinServer2012 and Win8.




  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    So sorry about this--I'm experiencing the same issue on my machine and it looks to be a new bug introduced in version 6.8 ( the /compactdb switch still works when I try with version 6.7 and older). I've logged a bug for it with reference SA-1376-- many thanks for bringing it to our attention!

    This is quite a hacky workaround but what one option to successfully use /compactdb for now is to install version 5 of SmartAssemblyon your machine (you'll have to uninstall version 6.8 first and then reinstall it after version 5 is set up). You can then run the /compactdb from the SA v.5 installation folder whenever needed.

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?

  • Options
    Was able to use that work around. Thanks for the link to v5. Thanks also for reporting the bug.
Sign In or Register to comment.