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 15Number of Views How to set up a cron job to move files older than x days to a remote location daily in RSA Authentication Manager 8.x 7Number of Views RSA enVision How to move collected devices logs using lsmaint utility 28Number of Views Move a Token Record to a New Security Domain 26Number of Views Overview of steps to move Authentication Manager 8.1 production data to VMware ESX 6.0 169Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?