Phone Lines icon GFI Support

Articles in this section

See more

How to move a GFI Archiver database to another Microsoft SQL Server

Author: Luis Fernandes Updated

Answer

  1. From the GFI Archiver web interface, select Configuration > Mail Servers to Archive > highlight Journal Mailbox > select Deactivate
  2. Wait 15 minutes to ensure that the archiving process has finished. It is recommended to check the following directories and ensure they are empty before proceeding:
    • ..\GFI\Archiver\Core\Pickup
    • ..\GFI\Archiver\Core\Queue
    • ..\GFI\Archiver\MAIS\Pickup
    • ..\GFI\Archiver\MAIS\Queue
  3. Select Configuration > Archive Stores > highlight Archive Store being moved > select Summary
  4. Note the paths listed (best to take a screenshot)
  5. Detach the Archive Store
  6. Stop all GFI Archiver services
  7. Backup the GFI Archiver database
    • From the Microsoft SQL Server Management Studio, select Databases > right-click <Database name> > Tasks > Backup Database
  8. Take GFI Archiver database offline
    • From Microsoft SQL Server Management Studio, select Databases > right-click <Database name> > Tasks > Take Offline
  9. Move the backup of the database files to the new Microsoft SQL server
  10. Create a new database
    • From Microsoft SQL Server Management Studio > right click Databases > New Database...
  11. Restore backup database file
    • From Microsoft SQL Server Management Studio > Databases > right click <Database name> > Tasks > Restore > Database
      • ​NOTE: The database name can be changed if required
    • From the Restore Database window > Source for restore section, select the option From device > select the backup database file
    • Check the box under Restore
    • Select Options > Restore Options > check Overwrite the existing database > OK
  12. Verify Owner for the database is SA account
    • From Microsoft SQL Server Management Studio > Databases > right click <Database name> > Properties > Files
  13. Start all GFI Archiver services
  14. From the GFI Archiver web interface, select Configuration > Archive Stores > Attach Archive Store using new database location and paths from step 4
  15. Once the databases are attached, click New Archive Store Settings, and complete the wizard using the new SQL server information
  16. Select Configuration > Mail Servers to Archive > highlight the journal mailbox > select Activate

Related articles