- Code: Select all
C:\\Program Files\\Red Gate\\SmartAssembly 6>SmartAssembly.com /compactdb
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.