Important Cookie Information

This website uses absolutely necessary cookies. If you consent to the use of convenience cookies, please click “Yes, I agree.” By clicking on “Privacy Settings.” you can change this setting at any time and withdraw your given consent. Icon down see more You can find detailled information in our Privacy Policy Icon forward-right
Icon up see less

Bosch Building Technologies

    cancel
    Showing results for 
    Search instead for 
    Did you mean: 

    How-to backup and restore Dicentis SQL databases

    Version(s): >= 2.71 (manual backup and restore is possible in older versions)

    Description:

    Especially when using large databases it is advisable to make a backup occasionally in case something goes wrong. The manual describes ways to backup, restore and update the database quickly. This document describes how to use these options and when and also an alternative way for older versions.

    Steps:

    Quick backup & restore:

    The steps on how to quickly backup and restore the Dicentis databases to a *.bak file can be found in the Dicentis Software Manual for DCNM-SW amongst other database manipulations;

    • Making a backup of the database
    • Restoring a database
    • Updating a database to the current version
    • Creating a clean database
    • Deleting a database

    A step that is occasionally omitted is the ‘update’ step. Even though the SQL version on which the database is running remains the same between Dicentis versions, the database version does change and needs to be updated when the backed up version was made on an earlier Dicentis version.

    When the Meeting Application is started without updating the database to the latest version, it will crash with a .NET error.

    In order to do update the database, follow the steps in the manual, reproduced here for convenience:

    1. Stop DICENTIS services using the DICENTIS Server Console.
    2. Open a command prompt in Administrator mode.
    3. Go to: C:\Program Files\Bosch\DICENTIS.
    4. To update the database to the current version, run exe.
    5. Restart the DICENTIS services using the DICENTIS Server Console.

    Manual backup & restore:

    Manual backup:

    1. Stop DICENTIS services using the DICENTIS Server Console.
    2. In Windows Services, stop SQL Server (SQLDICENTIS2014).
    3. Go to C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\.
    4. Copy the following files to the backup location (use a separate folder for each backup as files should not be renamed):
      1. DcnmDatabase.mdf
      2. DcnmDatabase_log.ldf
      3. DcnmLoggingDatabase.mdf
      4. DcnmLoggingDatabase_log.ldf
    5. In Windows Services, start SQL Server (SQLDICENTIS2014).
    6. Restart DICENTIS services using the DICENTIS Server Console.

    Manual restore & update:

    1. Stop DICENTIS services using the DICENTIS Server Console.
    2. In Windows Services, stop SQL Server (SQLDICENTIS2014).
    3. Go to C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\.
    4. Copy the following files from the backup location to this location:
      1. DcnmDatabase.mdf
      2. DcnmDatabase_log.ldf
      3. DcnmLoggingDatabase.mdf
      4. DcnmLoggingDatabase_log.ldf
    5. In Windows Services, start SQL Server (SQLDICENTIS2014).
    6. Open a command prompt in Administrator mode.
    7. Go to: C:\Program Files\Bosch\DICENTIS.
    8. To update the database to the current version, run exe.
    9. Restart DICENTIS services using the DICENTIS Server Console.
    Version history
    Revision #:
    1 of 1
    Last update:
    ‎08-29-2019 02:18 PM
    Updated by:
     
    Contributors
    Icon--AD-black-48x48Icon--address-consumer-data-black-48x48Icon--appointment-black-48x48Icon--back-left-black-48x48Icon--calendar-black-48x48Icon--center-alignedIcon--Checkbox-checkIcon--clock-black-48x48Icon--close-black-48x48Icon--compare-black-48x48Icon--confirmation-black-48x48Icon--dealer-details-black-48x48Icon--delete-black-48x48Icon--delivery-black-48x48Icon--down-black-48x48Icon--download-black-48x48Ic-OverlayAlertIcon--externallink-black-48x48Icon-Filledforward-right_adjustedIcon--grid-view-black-48x48IC_gd_Check-Circle170821_Icons_Community170823_Bosch_Icons170823_Bosch_Icons170821_Icons_CommunityIC-logout170821_Icons_Community170825_Bosch_Icons170821_Icons_CommunityIC-shopping-cart2170821_Icons_CommunityIC-upIC_UserIcon--imageIcon--info-i-black-48x48Icon--left-alignedIcon--Less-minimize-black-48x48Icon-FilledIcon--List-Check-grennIcon--List-Check-blackIcon--List-Cross-blackIcon--list-view-mobile-black-48x48Icon--list-view-black-48x48Icon--More-Maximize-black-48x48Icon--my-product-black-48x48Icon--newsletter-black-48x48Icon--payment-black-48x48Icon--print-black-48x48Icon--promotion-black-48x48Icon--registration-black-48x48Icon--Reset-black-48x48Icon--right-alignedshare-circle1Icon--share-black-48x48Icon--shopping-bag-black-48x48Icon-shopping-cartIcon--start-play-black-48x48Icon--store-locator-black-48x48Ic-OverlayAlertIcon--summary-black-48x48tumblrIcon-FilledvineIc-OverlayAlertwhishlist