Overview

The following procedure explains how to move your GFI EventsManager database from one Microsoft SQL Server to another. This information applies to GFI EventsManager 2011 and older versions.

Note: It is essential that you are familiar with Microsoft SQL Server and database administration prior to attempting to move any Microsoft SQL database.

Environment

GFI EventsManager 2011 and older.

Process

Backing up the GFI EventsManager Database

1. Stop the GFI EventsManager service.
2. From Microsoft SQL Server Management Studio, navigate to Databases.
3. Right click on Database name and select Tasks > Backup Database.
4. Perform a backup of the GFI EventsManager database.
5. From Microsoft SQL Server Management Studio, navigate to Databases.
6. Right click on Database name and select Tasks > Take Offline.
7. Move the backup of the database files on to the new Microsoft SQL server.

Note: The location of these files can vary from one setup to another.

Creating and transferring the new database

Proceed with the following instructions in the new SQL Server machine:

1. From Microsoft SQL Server Management Studio, navigate to Databases.
2. Right click on Databases and select New Database...
3. From Microsoft SQL Server Management Studio navigate to Databases.
4. Right click on Database name and select Tasks > Restore > Database (The database name can be changed if required).
5. In the Restore Database window's Source for restore section, select the option 'From device' and select the backup database file.
6. After adding the database file, make sure that you select the database to restore by enabling the checkbox under Restore.
7. Under Options > Restore Options, make sure that Overwrite the existing database is enabled
8. From Microsoft SQL Server Management Studio navigate to Databases.
9. Right click on Database name and select Properties > Files and make sure that you specify the Owner for the database, which you will use to configure the database within the GFI EventsManager configuration.

Configuring GFI EventsManager with the New Database

The following steps need to be carried out on the GFI EventsManager server:

1. Start the GFI EventsManager service.
2. Open the GFI EventsManager Management Console.
3. Click on the Configuration tab and select Options.
4. Click on the Database Backend node in the left pane and select Change database backend...
5. Under the Change database tab, enter the hostname or IP address of your SQL Server.
6. Click on the 'OK' button to save changes.

Note: If you have changed the database name on your new Microsoft SQL Server, ensure that you update the database name in the GFI EventsManager configuration.