How do I recover a deleted contact record? Process with restoring a GoldMine database backup and applying recent changes apart from the deleted record

Version 2

    Details

     

    How do I recover a deleted contact record? Process with restoring a GoldMine database backup and applying recent changes apart from the deleted record.

     


    Resolution

    - It is highly recommended prior any action also to review the related articles How to recover a deleted contact record: By deleting the related TLOG entries related to the original contact record and creating a transfer set on the backup data and How to recover a deleted contact record: By merging the original contact record into a new created record and creating a…  as  they contain different approaches for recovering a deleted Contact  Record within GoldMine

     

     

    1)  Have all users log out of GoldMine until this process is complete and results are verified

    2)  Make a current backup of GoldMine databases, folders, files

    3)  Determine the date/time the backup containing the deleted record was made

    4)  In the current install of GoldMine, select Tools > Synchronize > Synchronization Wizard to open the Wizard window

          a. Start a new session, Next >

          b. Create a transfer set, Next >

          c. Browse to the desired path, Next >

          d. Right click in Send Record Types, click Select All on pop-up menu then scroll down to red line and uncheck Deletions, Next >

          e. Select All changed contact records and check the appropriate contact set, Next >

          f.  Select ALL Contact Records, Next >

          g.  Set cutoff date time to an hour or so prior to time from step 3, Next >

          h.  Select No, Finish

    5)  When process completes, close GoldMine

    6)  Restore the backup containing the deleted record

    7)  Launch GoldMine and verify that the missing record is present

    8)  Retrieve the manual transfer set created in step 4 into the restored database

           a.  Select Tools > Synchronize > Synchronization Wizard to open the Wizard window

           b.  Start a new session, Next >

           c.  Retrieve a transfer set, Next >

           d.  Browse to path from 4c, Next >

           e.  Right click in Retrieve record types, click Select All on pop-up menu, Next >

           f.   Check appropriate Contact Set, Next >

           g.  Select No, Finish

    9)  Verify the missing record is still present.  Have a user familiar with data and functionality log in and check that all data and functionality is as expected.

    10) Note that any intentionally deleted data will need to be deleted again.

    11) Make a new backup of the database prior to allowing all users to log back in.

     

     


    Additional Note when restoring the backup database into the same Microsoft SQL Server Instance
    -  ATTENTION: in all 3 cases it might be necessary to rest the Service  Broker for the SQL database as restoring into the same SQL server will  create a duplicate Service Broker ID (see KM Article # 12856)

     

    1. Open the SQL Server Management Studio
    2. Open a New Query
    3. Copy and paste and adjust the following statement

     

    USE master
    GO
    ALTER DATABASE [DatabaseName] SET NEW_BROKER WITH ROLLBACK IMMEDIATE
    GO

     

    Replace DatabaseName with the upgraded and copied database name

    4. Execute the query