Microsoft Server SQL databases used by SDL Studio GroupShare 2015

You would like to know which databases are used to SDL Studio GroupShare 2015, e.g. because you want to delete unused databases or because you want to migrate the SDL Studio GroupShare databases to another Microsoft SQL server instance.

The following databases are used by GroupShare:

1. a GroupShare system database (all installations; default name: SDLSystem)
2. a MultiTerm master database (if MultiTerm Server component installed; default name: MTMaster)
3. termbase databases (if MultiTerm Server component installed; default names: MTMaster_X)
4. translation memory container databases (if TM Server component installed, no default names).

Refer to below instructions to identify all databases used by your SDL Studio GroupShare installation.
 

SDL GroupShare System Database

The default name for the GroupShare system database is SDLSystem. If the name differs, you can identify it on the server where GroupShare is installed:

1. Start the SDL Studio GroupShare Console.
2. Go to Console Root > SDL Studio GroupShare > Databases.
3. Check the Database Name in section GroupShare System Database.

 

MultiTerm Master Database

The default name for the MultiTerm master database is MTMaster. If the name differs, you can identify it on the server where GroupShare is installed:

1. Start the SDL Studio GroupShare Console.
2. Go to Console Root > SDL Studio GroupShare > Databases.
3. Check the Database Name in section MultiTerm Master Database.

Note: If the section MultiTerm Master Database is grayed out, your GroupShare installation does not include a MultiTerm Server component and thus no MultiTerm master database.
 

Termbase Databases

If your GroupShare installation includes a MultiTerm Server component, each termbase's data is stored in one database.

Via MultiTerm Administrator / Desktop

The name of each termbase database can be identified in MultiTerm Administrator and MultiTerm Desktop (Termbase Management view). The database name is displayed as Physical name when clicking on the termbase.
 

In MultiTerm Master Database

1. Identify the MultiTerm master database according to above instructions.
2. In the MultiTerm master database, retrieve all entries of the table dbo.Termbases.
3. The names of all termbase databases used by GroupShare are listed in the column PhysicalName.

 

Translation Memory Container Databases

Via GroupShare WebUI

1. Log into GroupShare WebUI by accessing your server's URL in a web browser.
2. Go to Infrastructure.
3. Activate tab Containers.
4. For each container listed, the Database Name corresponds to a database used by GroupShare.

In GroupShare System Database

1. Identify the GroupShare system database according to above instructions.
2. In the GroupShare system database, retrieve all entries of the table etm.Container.
3. The names of all TM container databases used by GroupShare are listed in the column ContainerName.

Note: If your GroupShare system database does not contain a table etm.Container, your GroupShare installation does not include a TM Server component. In this case, it does not use any TM container databases.

For information about SDL Trados GroupShare 2017, refer to the following knowledge article: 

• Microsoft Server SQL databases used by SDL Trados GroupShare 2017 and 2017 SR1