How to manually create a backup of Security Analytics Database in RSA Security Analytics

Issue

How to manually create a backup of  Security Analytics Database in RSA Security Analytics.

Resolution

Please ssh to the SA appliance as root user and follow the steps below to manually create a snapshot of the SA DB

stop jettysrv

cd /var/lib/netwitness/uax/db/
wget http://repo1.maven.org/maven2/com/h2database/h2/1.2.147/h2-1.2.147.jar

java -cp h2-1.2.147.jar org.h2.tools.Shell -url jdbc:h2:file:platform

SQL> backup to '/var/lib/netwitness/uax/db/db.backup.2014.05.15';  (Please change the date to reflect the current date)

SQL>quit;

You can now see the new backup file created in  /var/lib/netwitness/uax/db/db.backup.2014.05.15

start jettysrv

Notes

SA Server creates a snapshot of the database under /var/lib/netwitness/uax/db every 12 hours or upon jettysrv restart. The snapshot files are created in the following format: "platform.h2.db.backup.timestamp.zip" .

We currently have a known issue where the db snapshots are not working as expected. This is tracked in the JIRA ticket SACE-1102.

Internal Comments

UserName:shurtj
8/7/2014 8:18:02 PM - Updated Article
Updated article and made changes to abide by Primus best practices.

UserName:salmeida
4/8/2014 8:18:02 PM - Archive
to be archive we have NRT and backup tools.

Product Details

RSA Security Analytics
RSA Security Analytics 10.3
INTERNAL ONLY !!!!

Approval Reviewer Queue

Technical approval queue