Here is a quick blog around migrating Citrix Session Recording Databases to a new SQL server. This is only a single instance and it’s not load balanced. It’s a very basic configuration and I wanted to go into the CTX article a bit more.
1. Stop the Services on your recording server.
2. Take a full backup of existing Session Recording databases (SessionRecording and SessionRecordingLogging).
3. Copy backed up databased to the new SQL server.
4. Restore Session recording and logging databases in the new SQL server.
5. Create new logon with Session Recording server hostname in SQL server under Security -> Logins
6. This is an example from the Citrix KB for the permissions.
7. Add both databases to Always on High Availability (if there is Always on configured).
8. Take backup of “C:\Program Files\Citrix\SessionRecording\Database\Bin\SsRecDatabase.InstallState”
9. Updated meaning the file is backed up “Taken backup of “C:\Program Files\Citrix\SessionRecording\Database\Bin\SsRecDatabase.InstallState” with a new SQL Server or Always-On Listener address.
10. Updated following registry with new SQL Server or Always-On Listener address.
11. Before Database move:
12. Update this location for the new Database name: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Citrix\SmartAuditor\Database\SmAudDatabaseInstance
13. Then update the location as well to the new database name: HKEY_LOCAL_MACHINE\SOFTWARE\Citrix\SmartAuditor\Server\SmAudDatabaseInstance
14. Start services (Citrix Session Recording Analytics Service, Citrix Session Recording Storage Manager).
15. If you don’t have the permission correct you will be receiving something very similar to this:
16. Citrix Database has been restored:
17. Test recording.