Quick Blog on how to migrate Citrix Session Recording databases

 

How to migrate Citrix Session Recording databases

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

 

 

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.

5. Add both databases to Always On High Availability (if there is Always on configured)

 

 

6. Take backup of "C:\Program Files\Citrix\SessionRecording\Database\Bin\SsRecDatabase.InstallState"

 

7. 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.

 

8. Updated following registry with new SQL Server or Always-On Listener address.

 

 

10. Before DB name

 

 

11. Update this location  for the new Database: 

12. HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Citrix\SmartAuditor\Database\SmAudDatabaseInstance

 

 

13. Then update the location as well to the new database name

14. HKEY_LOCAL_MACHINE\SOFTWARE\Citrix\SmartAuditor\Server\SmAudDatabaseInstance

 

 

 

 

 

15. Start services (Citrix Session Recording Analytics Service, Citrix Session Recording Storage Manager).

 

 

15. Citrix Database has been restored

 

 

16. Test recording