Actions need to perform while migrating Citrix Session Recording Databases .

Instructions

• Take full backup of existing Session Recording databases (SessionRecording and SessionRecordingLogging)
• Copy backed up databased to the new SQL server.
• Restore Session recording and logging databases in new SQL server.
• Create new logon with Session Recording server hostname in SQL server under Security -> Logins
• 
• Add both databases to Always On High Availability (if there is Always on configured)
• Logon to Session Recording server and stop services (Citrix Session Recording Analytics Service, Citrix Session Recording Storage Manager).
• Take backup of "C:\Program Files\Citrix\SessionRecording\Database\Bin\SsRecDatabase.InstallState"
• Updated "Taken backup of "C:\Program Files\Citrix\SessionRecording\Database\Bin\SsRecDatabase.InstallState" with new SQL Server or Always-On Listener address.
• Updated following registry with new SQL Server or Always-On Listener address.
  HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Citrix\SmartAuditor\Database\SmAudDatabaseInstance
  HKEY_LOCAL_MACHINE\SOFTWARE\Citrix\SmartAuditor\Server\SmAudDatabaseInstance
• Start services (Citrix Session Recording Analytics Service, Citrix Session Recording Storage Manager).