RWS Community
RWS Community
  • Site

Trados Studio

Trados Team

Trados Accelerate

Trados Enterprise

Trados GroupShare

Trados Business Manager

Passolo

MultiTerm

RWS AppStore

Connectors

Beta Groups

Managed Translation

MultiTrans

TMS

Trados Enterprise

WorldServer

Language Weaver

Language Weaver Edge

Language Weaver Connectors

Language Weaver in Trados Studio

 

 

Tridion Docs

Tridion Sites

Contenta

LiveContent

XPP

Trados Studio Ideas

Trados GroupShare Ideas

Trados Team Ideas

Trados Team Terminology Ideas

Trados Enterprise & Accelerate Ideas

Trados Business Manager Ideas

MultiTerm Ideas

Passolo Ideas

RWS Appstore Ideas

Tridion Docs Ideas

Tridion Sites Ideas

Language Weaver Ideas

Language Weaver Edge Ideas

Managed Translation - Enterprise Ideas

TMS Ideas

WorldServer Ideas

Trados Enterprise Ideas

XPP Ideas

GroupShare Developers

Language Cloud Developers

MultiTerm Developers

Passolo Developers

Trados Studio Developers

Managed Translation Developers

TMS Developers

WorldServer Developers

Tridion Docs Developers

XPP Developers

Language Combinations by Language Services

RWS Training & Certification

Style Guides

RWS Campus

Trados Approved Trainers

ETUG (European Trados User Group) Public Information

Nordic Tridion Docs User Group

Tridion West Coast User Group

Community Ops

demospace

RWS Community Internal Group

AURORA

Internal Trados Ideas

Linguistic Validation

Mercury

XPP Cloud

Recognition & Reward System

RWS Community Platform Related Questions

Community Solutions Hub (Trados)

Events

RWS Training & Certification

To RWS Support

  • Search
  • Translate

    Detecting language please wait for.......


    Powered by
  • User
  • Site
  • Search
  • User
  • Products
  • Trados Portfolio
  • Trados Business Manager
  • More
  • Cancel
Trados Business Manager
  • Products
  • Trados Portfolio
  • Trados Business Manager
  • More
  • Cancel

Trados Business Manager > Wiki

Essential - database file
  • Home
  • Blog and Product Updates
  • Forums
  • Wiki
  • Ideas
  • Docs
  • More
  • Cancel
  • New
Show Translation Options

Detecting language please wait for.......


Powered by
Trados Business Manager requires membership for participation - click to join
  • Wiki
  • +Licensing & Installation
  • -TBM 6
    • +Release Notes
    • +Basic Information
    • Quick Start
    • +Database engine
    • -Software configuration
      • Application settings
      • Application language
      • Application fonts and colors
      • Essential - change default port
      • Essential - database file
      • Limit access by IP addresses
    • +List views and data entry forms: usage and customization
    • Dashboards
    • +Reference data
    • +Documents
    • +Security system
    • +Service functions
    • +Data export and import
    • +Reports and analytics
    • +Invoice templates and custom reports
    • API
    • +Portal for customers
    • +Portal for Vendors
    • +Integrations in Business Manager
    • +CV
  • +Trados Business Manager Connector plugin
  • +Trados Business Manager plugin
  • +FAQ
  • TBM 5 documentation
  • Download links for older versions

Essential - database file

This article explains where all the data is stored in the Essential version, so you can safely copy/move/backup/restore your data without worrying to loose it.

Actually, there are only 2 files where your data and application configuration is stored: 

  • tbmdb.sqlite (database file). Default location: InstallationFolder\resources\bin\database.
  • appsettings_global.json (config file). Default location: InstallationFolder\resources\bin\.

In the application settings, you could change default database file location. In this case, you can find the path in the appsettings_global.json, under ConnectionStringLocal key.

Resetting database and database version

Config file contains one important key: DatabaseVersion. Initially, database version is 0. With time, when application gets updated, database version is increased. When you launch application, the system checks DatabaseVersion value, and if it's lower than the latest version, application will attempt to update database to latest version.

Example. If you delete database file and launch TBM, the system, will create empty database file, then read DatabaseVersion value, and if that value equals to latest version, upgrade won't happen, and you'll get non-initialized database. This means, that to start from scratch, you should not only delete database file, but also change DatabaseVersion value in the config file to 0.

Manual backup

Just copy 2 mentioned files to safe location.

Manual backup restore

You can just copy backup file to the database location and change it's name to tbmdb.sqlite. Be careful - if such file already exists, maybe it will be necessary to backup it, to avoid accidental overwriting. Additionally, it is recommended to restore appsettings_global.json file as well, or change DatabaseVersion value manually, if backup was created earlier, and after that you have installed any updates.

  • Share
  • History
  • More
  • Cancel
Related
Recommended
  • Our Terms of Use
  • Copyright
  • Privacy
  • Security
  • Anti-slavery Statement
  • Cookie Notice
  • YouTube