Moving Firewall Analyzer's database/ index to different directory in the same server


 

How to move PostgreSQL data to another drive in the same physical machine? 

Follow the steps given below to move the database to a different drive:

For Linux: 

Edit the following set database home line: 

DB_HOME=$SERVER_HOME/pgsql 
as 
DB_HOME=<absolute path of desired location>/pgsql 

where, the <absolute path of desired location>/pgsql is the new location for the PostgreSQL database. 

Note The above line may slightly differ for various builds, however, ensure that, 
in Windows "set DB_HOME=%SERVER_HOME%\pgsql" is changed to "set DB_HOME=<new drive with absolute path>\pgsql
or 
in Linux the line is changed to "DB_HOME=<absolute path of desired location>/pgsql". 

 

 

 

How to move MSSQL data to another drive in the same physical machine?

  1. Stop the Firewall Analyzer Server/Service.
  2. Login to SQL Server database with system administrator permissions.
  3. Find the current location of the data file and log file for the database firewall by using the following commands:

use firewall
go
sp_helpfile
go

  1. Detach the database by using the following commands:

use  master
go
sp_detach_db 'firewall'
go

  1. Copy the data file and log file from the current location (<MSSQL Home>\data\firewall.mdf and <MSSQL Home>\data\firewall_log.LDF)
    to the new location (<New location>\firewall.mdf and <New Location>\firewall_log.LDF).
  2. Re-attach the database and point to the new location by using the following commands:

use  master
go
sp_attach_db 'firewall' , '<New Location>\firewall.mdf' , '<New Location>\firewall_log.LDF'
go

  1. Verify the changed location by using the following commands:

use firewall
go
sp_helpfile
go

  1. Start the Firewall Analyzer Server/Service.

 

How to move the Firewall Analyzer's Indexes to a different drive/directory on the same server

 

Copyright © 2012, ZOHO Corp. All Rights Reserved.
ManageEngine