Failed to compress sde database

Question

Hi all!

I've been trying to compress our sde database, but the attempt fails with an error message relating to the ODBC driver and an unspecified error as shown in the attached image.

Any idea how I can fix it, so I'm able to compress the database again?

Thanks in advance!!

Marc Seliger

South_JordanCity_of · Answer

Thanks for your reply Randall, I will check out the proposed fix and see if it fixes our issue.

Marc

RandallWilliams · Answer

I'd try the advice in this thread and rebuild all of the spatial indexes.

https://community.esri.com/thread/197950-failure-to-access-the-dbms-server-microsoftsql-server-native-client-110communication-link-failure-sdedefaultstateid-251-underlying-dbms-error-hy000microsoftsql-server-native-client-110unspecified-error-occurred-on-sql-server