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
- Stop GFI EventsManager and GFI EventsManager Monitor services. Check Task Manager after you stop all the EventsManager services and kill any EventsManager process.
- From the GFI EventsManager console, go to Configuration > Options > Configurations.
- Click File storage > Configure file storage…
- On the General tab, verify the current database name and if there exists any old database as a result of database rotation.
- If there is only one database (database rotation disabled), a new database must be created in order to move the data. Do the following:
- Try to free up some disk space by other means (e.g. deleting temporary files).
- Click on New... , set a new database name and hit OK.
- 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.
- Close the GFI EventsManager console.
- Open a command prompt window and run it as administrator.
- Change to the directory where your database server was installed (e.g.: cd "C:\Program Files (x86)\GFI\Database Server 2.1")
- 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>
- Once the database movement for all required databases is completed, start the services that were stopped in Step 1.
- Start the GFI EventsManager console and verify that it is working as required.
Note: You will still be able to switch to the DB that you moved to review records.