Overview

This article provides steps to move the old database information to another location if database rotation is enabled. A few things to consider:

• When database rotation is not enabled and disk runs full, the best way is to create a new blank database and move the active database to another drive.
• If the disk is not full yet and doing database rotation is not desired, please follow the steps outlined in article Purging Old Events from GFI EventsManager Database.

Process

1. Stop GFI EventsManager and GFI EventsManager Monitor services.
2. From the GFI EventsManager console, go to Configuration > Options > Configurations.
3. Click File storage > Configure file storage…
4. On the General tab, verify the current database name and if there exists any old database as a result of database rotation.
5. If there is only one database (database rotation disabled), a new database must be created in order to move the data. Do the following:
   1. Try to free up some disk space by other means (e.g. deleting temporary files).
   2. Click on New... , set a new database name and hit OK.
6. Take note of the path (C:\Program Files (x86)\GFI\Database Server 2.1\Databases\ by default) and the database names you wish to move.
7. Close the GFI EventsManager console.
8. Open a command prompt window and run it as administrator.
9. Change to the directory where your database server was installed (e.g.: cd "C:\Program Files (x86)\GFI\Database Server 2.1")
10. For each database that you want to move, replace Source Path, Destination Path, and Database Name by executing the following command:

    DlibAdm /copyMoveDLib /sourcePath:<source path> /destinationPath:<destination path> /copyMove:-m /dbName:<database name>

11. Once the database movement for all required databases is completed, start the services that were stopped in Step 1.
12. Start the GFI EventsManager console and verify that it is working as required.