Hey all, anyone dealt with splitting a combined Si...
# _general
n
Hey all, anyone dealt with splitting a combined Site/Monitoring/Logging database in CVAD 2507 LTSR CU1? My client site has been running for years with a single combined SQL database (4.0 GB) and I want to split it into three separate databases per Citrix best practices.Main concern is historical data — the Citrix docs say the Studio "Change Database" option creates a fresh empty schema and doesn't migrate anything. Has anyone found a supported way to preserve the Monitoring and Logging history during the split? Also curious if anyone has used this method and if it's considered safe: https://jgspiers.com/moving-logging-monitoring-database/? Already reviewed CTX270731, CTX324187, and the 2507 LTSR database docs but couldn't find a clear answer on data preservation. Any feedback appreciated.
r
I vaguely remember us splitting our databases successfully, but that was like 10 years ago. The steps in jgspiers's article look right. Do you have or could you spin up a non-prod environment for testing?
n
#CK6TCV3JN - Fyi, i was able to do this in my lab environment through the gui using the change database w/o any issues. i did not need to run an additional powershell commands... just not sure if its supported..
👍 1