topic Re: Failed to compress sde database in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/failed-to-compress-sde-database/m-p/393416#M15273 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply Randall,&nbsp;I will check out the proposed fix and see if it fixes our issue.</P><P></P><P>Marc</P></BODY></HTML> Thu, 17 Aug 2017 21:32:53 GMT South_JordanCity_of 2017-08-17T21:32:53Z Failed to compress sde database https://community.esri.com/t5/arcgis-enterprise-questions/failed-to-compress-sde-database/m-p/393414#M15271 <HTML><HEAD></HEAD><BODY><P>Hi all!</P><P>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.</P><P></P><P><IMG alt="compress error" class="image-1 jive-image j-img-original" src="/legacyfs/online/367442_2017-08-17 09_09_38-Compress Database.png" style="width: 620px; height: 333px;" /></P><P></P><P>Any idea how I can fix it, so I'm able to compress the database again?</P><P>Thanks in advance!!</P><P></P><P>Marc Seliger</P></BODY></HTML> Thu, 17 Aug 2017 15:51:13 GMT https://community.esri.com/t5/arcgis-enterprise-questions/failed-to-compress-sde-database/m-p/393414#M15271 South_JordanCity_of 2017-08-17T15:51:13Z Re: Failed to compress sde database https://community.esri.com/t5/arcgis-enterprise-questions/failed-to-compress-sde-database/m-p/393415#M15272 <HTML><HEAD></HEAD><BODY><P>I'd try the advice in this thread and rebuild all of the spatial indexes.</P><P></P><P><A _jive_internal="true" href="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">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</A></P></BODY></HTML> Thu, 17 Aug 2017 16:34:14 GMT https://community.esri.com/t5/arcgis-enterprise-questions/failed-to-compress-sde-database/m-p/393415#M15272 RandallWilliams 2017-08-17T16:34:14Z Re: Failed to compress sde database https://community.esri.com/t5/arcgis-enterprise-questions/failed-to-compress-sde-database/m-p/393416#M15273 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply Randall,&nbsp;I will check out the proposed fix and see if it fixes our issue.</P><P></P><P>Marc</P></BODY></HTML> Thu, 17 Aug 2017 21:32:53 GMT https://community.esri.com/t5/arcgis-enterprise-questions/failed-to-compress-sde-database/m-p/393416#M15273 South_JordanCity_of 2017-08-17T21:32:53Z