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
Newer structure GDB (ignore highlighted connection, it highlights the bottom one no matter what is selected)
Any advice how to fix this? Thanks in advance