RSA DLP How to migrate RSA_DLP_EM database host server
2 years ago
Originally Published: 2016-04-25
Article Number
000067516
Applies To
RSA Product Set: RSA DLP
RSA Product/Service Type: Enterprise Manager
RSA Version/Condition: 9.6 SP2
Platform: Windows Server 2008/2012

 
Issue
- This article provides an insight on the steps required to be done on both the SQL server & Enterprise-Manager server when migrating the DLP SQL server to a different server/VM.
 
Resolution
Note: Please make sure to take full backup of the database to the new server before doing these steps.

First: Enterprise Manager Changes:

Step1: Stop the Enterprise Manager Service

On the new EM, go into the Services control manager [services.msc]  and stop the RSA DLP Enterprise Manager service.

Step 2: Configure the EM to Use the new Database

Open Windows Explorer on the Enterprise Manager and navigate to the following directory.

C:\Program Files (x86)\RSA\Enterprise Manager\webapps\root\WEB-INF\classes
From that directory, open the file “application. Properties”  using Notepad/Wordpad (or any text editor). Look for the line that begins with “jdbc.url=”.
This is generally one of the first lines.
There are three things we will need from this line:
  • The SQL server name
  • The SQL instance name
  • The database name.

As an Example:

jdbc.url=jdbc:sqlserver://BostonSQL;instanceName=DLPInstance;sendStringParametersAsUnicode=true;integratedSecurity=true;selectMethod=cursor;encrypt=true;trustServerCertificate=true;databaseName=RSA_DLP_EM;

-BostonSQL is the name of the SQL server
-DLPInstance is the name of the SQL instance containing the DLP database (In many installations, a SQL instance will not be shown. This is normal if the default SQL instance was used for the installation)
-The database name is given at the end of the line, RSA_DLP_EM in this case.
- Change the SQL server name to the new IP or hostname


Second: Database Changes:
  1. Go to Host A, Open SQL Server Management Studio. Explore Databases.
  2. Right click on RSA_DLP_EM Database and select Task->Detach.
  3. Select check boxes for Drop connection, Update Statistics, Keep Full Text catalogs and click [OK].
  4. Copy RSA_DLP_EM_log.LDF & RSA_DLP_EM.mdf files from Server A to Server B : This files can be found on server A at:
<SQL Server instance location>, for example: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
  1. Go to Host B, Open SQL Server Management Studio.
  2.  Right click on Databases and select [Attach].  
  3. Click on [Add], provide the mdf file location, which we saved in step 5. 
  4. Click [OK] and that will create RSA_DLP_EM database on Host B.
 Step 3: Start the Enterprise Manager Service

 

Related Articles

Trending Articles

Don't see what you're looking for?