How to move the StealthAUDIT DAG database to a new server in RSA Identity Governance & Lifecycle
Originally Published: 2020-05-11
Article Number
Applies To
RSA Version/Condition: All
Issue
Tasks
Resolution
- Close the StealthAUDIT database.
- Check task manager and make sure no StealthAUDIT processes are running.
- Temporarily disable any scheduled tasks. The easiest way to do this is:
- Go into the schedules section of the StealthAudit console.
- CRTL click on all the scheduled jobs.
- Right click > Disable
- Detach and move the database. (Follow the Microsoft recommended procedure - this is not a StealthBIT procedure.)
- Ensure account(s) have the appropriate rights on the new database.
- Create a new Storage Profile in StealthAUDIT for the new database server:
- Open StealthAUDIT. You will receive a message about not being able to connect to the database.
- Navigate to Settings > Storage
- Add a new storage profile by using the name of your new database server.
- Look for the expected database name (usually StealthAUDIT), and make sure it is set to the default.
- You will be asked if you want to migrate information – choose No.
- Re-enable your scheduled tasks.
Notes
If new permissions need to be applied, make sure that all users connecting to the StealthAUDIT database have:
- Database owner rights on the StealthAUDIT database.
- A dbo default schema.
Another option is to start totally fresh, but the downside would be losing historical data.
Best practice info:
- Use simple recovery mode - not full mode - else the log files could get enormous.
- Change auto-growth to grow by percentage 20% or so (this can interfere with Jobs if it is growing all the time - the default grows every 1MB which can cause slowness.)
Related Articles
How to move users from one group to another in RSA ACE/Server Administration API Number of Views Unable to authenticate through Radius devices after moving the ACE/Server to a new machine. Number of Views How to move BINs from one FI to another in same region Number of Views How to fix error "-bash: /usr/bin/Check_Instance_Running.sh: /bin/ksh: bad interpreter: No such file or directory" while i… Number of Views Move Users Between Security Domains Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide How to Download OTP Token Seed Files from myRSA Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU
Don't see what you're looking for?
