1. Home
  2. Docs
  3. Administration
  4. How to backup the database

How to backup the database

It is very important to periodically make a copy of the database for backup & restore purposes. It is also recommended prior to installing a software update or upgrade.

Important! Make sure that all users are out of FastMaint before trying to make a copy of the database.

 

1. FastMaint Basic/ Standard

The database files are FastMaint.mdb and FastMaint.mdw. These files may be found in FastMaint install directory (usually “c:\Program Files\fastmaint” OR on 64-bit systems “C:\Program Files (x86)\fastmaint”). Copy these two files and keep the backup copies in a safe place.

To restore a copy of the database first make sure all users are out of FastMaint. Then copy the backup database file(s) over the existing file(s) in the database location. This will return your database to the prior state.

 

2. FastMaint Professional

Not sure of the database type you are using or the location?
Open the “FastMaint.ini” text file with NotePad. It will be found in the FastMaint install directory (usually “c:\Program Files\fastmaint” OR on 64-bit systems “C:\Program Files (x86)\fastmaint”). Make sure not to modify this file! If you see the line “Database=SQL SERVER” you are using SQL Server. Otherwise you are using the internal MS Access/ Jet database.

Using internal MS Access/ Jet database:
The database files are FastMaint.mdb and FastMaint.mdw. Copy these two files and keep the backup copies in a safe place. The database files will be in the location specified in the “FastMaint.ini” file in the line “Database=”.

To restore a copy of the database first make sure all users are out of FastMaint. Then copy the backup database file(s) over the existing file(s) in the database location. This will return your database to the prior state.

Using an external Microsoft SQL Server database:
Check the value specified in “DSN=” to identify the ODBC DSN setting. Look for this DSN in the ODBC Manager (32 bit) on the local computer  to find the SQL Server database being used. Please check with your database administrator about making a copy of the database or restoring from a backup.

 

3. FastMaint Web

Not sure of the database type you are using or the location?
If you are using the built-in web server you can look for this information in the Setup page. Otherwise, to find out which database is being used, go to the “fastmaint” sub-folder in the program install directory. In this sub-folder look for the file named “Web.config“. Open this file with NotePad. Make sure not to modify this file! Look for the following line (search for DBPath):

<add key=”DBPath” value=”…. />

The contents of value will tell you if it is using the built-in Microsoft Access/ Jet database or an external Microsoft SQL Server database (value will contain a reference to SQLOLEDB). It also will have information about the database server, database name (on the database server), etc. If using the built-in Microsoft Access/ Jet database it will contain the file path to the database file.

Using internal MS Access/ Jet database:
There is a single database file fmweb.mdb. It will be located in a directory specified on the Setup page when running the built-in web server. Alternatively you can locate the database using the “Web.Config” file (see above). You will need to see the “Web.Config” file if you are hosting FastMaint Web on Microsoft’s Internet Information Server.

To restore a copy of the database first make sure all users are out of FastMaint. Then copy the backup database file over the existing file in the database location. This will return your database to the prior state.

Using an external Microsoft SQL Server database:
Please check with your database administrator about making a copy of the database or restoring from a backup.

 

4. FastMaint Cloud

The database is stored on our servers. You can download/ backup your database by visiting your subscription management page (Home page, Administration tab, Subscription Details, Tools tab). Please contact us if you need to restore an old version of your database.

 

Was this article helpful to you? Yes 1 No