A few of our Geodatabases will not compress all the way to State 0. They are hanging up at end state 2. I am not sure the process of troubleshooting this problem. Everything is syncing nightly and our compress is running weekly. Everything is running fine but they will not compress to state 0. I am looking for ways of finding out what is holding them back from rolling all the way to state 0.
I stop all map and feature services , and kill all direct connections to these databases before I compress , rebuild , and analyze.
Any help would be greatly appreciated.