Yesterday, one of our admins mistakenly changed the field type for one of our primary fields (used in 9 templates). This change completely wiped out the pre-existing data for that field (6.4 million+ entries affected). I am trying to resolve this problem as soon as possible due to our staff's inability to locate documents and process documents. We attempted to manually re-add the metadata using workflow, but this would take us over a month to replace the metadata. 

I reached out to our VAR and they advised us to do a restore, no details just do a restore since all the metadata was lost. I am looking for some guidance on what I actually need to have restored. I believe there are a lot of moving parts associated with the way we use Laserfiche and I want to ensure that we are going about this the right way....as of right now I have a copy of the SQL db backup (From Sunday and Yesterday), already live mounted in Rubrik. My db admin though is not confident that simply restoring this one db will resolve the problem in its entirety.

 Just for clarity we determined the lost items by using the following query:

Pull all TWIST IDs

SELECT        TWISTID, CAST(tocid AS int) AS EntryID

FROM            (SELECT DISTINCT tocid,

                                                        (SELECT        str_val

                                                          FROM            dbo.propval

                                                          WHERE        (prop_id = 15) AND (tocid = t.tocid) AND (pos = 0)) AS TWISTID

                          FROM            dbo.toc AS t

                          WHERE        (toc_flags & 0x800 = 0)) AS z

WHERE        (TWISTID IS NOT NULL)