AnsweredAssumed Answered

Losing "structure" of SDE geodatabase

Question asked by RasheedKh on Apr 6, 2020
Latest reply on Apr 6, 2020 by George_Thompson-esristaff

We are using ArcGIS Desktop 10.8 using SQL Server 2016 for enterprise geodatabases from legacy SDE. The newer gdb's seem to work ok, but I'm noticing lately that the SDE, with the most critical data, loses its "structure," that is feature datasets, feature classses are replaced with tables ending with _evw. I don't know a whole lot about SQL Server, and less about legacy SDE, but the only way I can currently get data back how it was is to restore the databases and just not compress. 

 

SDE geodatabase after compression 

Geodatabase lost structure

 

Newer structure GDB (ignore highlighted connection, it highlights the bottom one no matter what is selected)

Newer GDB

 

Any advice how to fix this? Thanks in advance

Outcomes