We need to find out what version of GoldMine we were last running, because the server crashed and the application is not available anymore and only a SQL backup of the GoldMine database is available

Version 1

    Details

    We need to find out what version of GoldMine we were last running, because the server crashed and the application is not available anymore and only a SQL backup of the GoldMine database is available 


    Resolution

    [INFORMATION]

    - One possibility would be to verify any existing clients, which should be always running the identical version and build as the application, another possibility would be to verify any existing remote sites/users which version of GoldMine they are running as also synchronization requires both sides to be on the same version and build for a successful synchronization
    - If this is not possible due to any reasons then the Database itself contains the last run version of GoldMine in the ENVIRONMENT table 

    [VERIFICATION]
    1. Restore the GoldMine database backup to SQL via Management Studio
    2. Run the following SQL query against the restored GoldMine database:

    [INFORMATION]
    - One possibility would be to verify any existing clients, which should be always running the identical version and build as the application, another possibility would be to verify any existing remote sites/users which version of GoldMine they are running as also synchronization requires both sides to be on the same version and build for a successful synchronization
    - If this is not possible due to any reasons then the Database itself contains the last run version of GoldMine in the ENVIRONMENT table 

    [VERIFICATION]
    1. Restore the GoldMine database backup to SQL via Management Studio
    2. Run the following SQL query against the restored GoldMine database:

    select * from ENVIRONMENT where NAME ='CUR_GM_VERSION'

    3. The value in the VAL column will show the GoldMine version including the build information



    Please refer to the related Knowledge Article # 25274 - GoldMine Premium Edition versions and build numbers