Finding the Location of your ASA Database File

Symptoms

The OfficeTalk ASA database file may need to be located for backup or restore purposes, or for helping with support and troubleshooting incidents.

Detail

The ASA database server will be running on the computer upon which you first installed OfficeTalk. Note, this may or may not be the same computer as your MailGateway/Rules Processor.

Typically, your ASA database will exist in %systemroot%OTalk and be called otsqldb. However, this will vary in accordance with the version of OfficeTalk and ASA that you currently have installed. Where necessary use the relevant steps below.

ASA 5 (OfficeTalk 98 installations)

1. On the computer with the database server installed and running, maximise the ASA server process that is running with a red SQL icon in the task bar.
2. You will see a large amount of text in the Messages window. Scroll to the top.
3. You will see a line such as the following: C:OTalkOTSQLDB.DB started.
4. In this example, C:OTalkOTSQLDB.DB is your database path and filename.

ASA 8 (OfficeTalk 4.0 installations)

1. Click Start >> Run and type Regedit followed by Enter
2. Navigate to and expand the following key: HKEY_LOCAL_MACHINESystemCurrentControlSetServicesASANYs_otdbv4Parameters
3. Open Parameters, it will have the following value: C:OTalkOTSQLDBV4.DB -n otdbv4 -x tcpip -m
4. In this example, C:OTalkOTSQLDBV4 is your database path and filename. You’re able to identify this because of the .DB file extension.

ASA 9 (OfficeTalk 4.1 and 4.5 installations)

1. Click Start >> Run and type Regedit followed by Enter
2. Navigate to and expand the following key: HKEY_LOCAL_MACHINESystemCurrentControlSetServicesASANYs_OfficeTalkParameters
3. Open Parameters, it will have the following value: -m -c 10M -gn 20 -n OTDB “C:OTalkOTSQLDB.DB”
4. In this example, C:OTalkOTSQLDB.DB is the database path and filename. You’re able to identify this because of the .DB file extension.