Edits Lost When Version Deleted

jay.guarneri_pww

We have a straightforward versioning system, with just one child version off of default at the moment. We reconcile and post edits regularly (every other day at the least frequent), and compress, index, and analyze the database nightly. We had to delete the child version yesterday for some other database maintenance, and all of the edits performed in that version from the last three weeks were gone. We're pulling a copy of the backup so we can recover the edits, but I'm wondering what would cause this in the first place. My recollection is that the edits had been showing up in default; hopefully the backup doesn't prove me wrong...

RebeccaStrauch__GISP

I agree with Jake that they probasbly weren't all pushed to the DEFAULT.

Before we ever delete a child version (or compress for that matter), we run a few queries to make sure things are pointing to the same version.  We also use the GDBT(ools) that is old, and will not install without messing with things a bit, but it can give you a nice graphic.

For our SQL sde, the commands I run using Microsoft SQL Server Management Studio (SSMS)  before and after compress:

<SPAN class="keyword token">use</SPAN> <SPAN class="operator token"><</SPAN>our_sde_database<SPAN class="operator token">></SPAN>
<SPAN class="keyword token">select</SPAN> name<SPAN class="punctuation token">,</SPAN> owner<SPAN class="punctuation token">,</SPAN> version_id<SPAN class="punctuation token">,</SPAN> state_id<SPAN class="punctuation token">,</SPAN> parent_name<SPAN class="punctuation token">,</SPAN> parent_owner <SPAN class="keyword token">from</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="operator token"><</SPAN>our_sde_database<SPAN class="operator token">></SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>dbo<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>SDE_versions<SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">select</SPAN> <SPAN class="operator token">*</SPAN> <SPAN class="keyword token">from</SPAN>&nbsp; <SPAN class="punctuation token">[</SPAN><SPAN class="operator token"><</SPAN>our_sde_database<SPAN class="operator token">></SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>dbo<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>SDE_versions<SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">select</SPAN> <SPAN class="operator token">*</SPAN> <SPAN class="keyword token">from</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="operator token"><</SPAN>our_sde_database<SPAN class="operator token">></SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>dbo<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>SDE_states<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">order</SPAN> <SPAN class="keyword token">by</SPAN> state_id
<SPAN class="keyword token">select</SPAN> <SPAN class="operator token">*</SPAN> <SPAN class="keyword token">from</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="operator token"><</SPAN>our_sde_database<SPAN class="operator token">></SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>dbo<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">[</SPAN>sde_state_lineages<SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">order</SPAN> <SPAN class="keyword token">by</SPAN> lineage_name<SPAN class="punctuation token">,</SPAN> lineage_id<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I do it before the compress just to see a count of the changes, etc.  I do it after to make sure the state_id is the same.  I do not delete a good Child unless the state_id is the same....and preferably zero.  I would also do a compress after deleting the child...which should put you at zero if you weren't already.