Having performed a backup with Activity Logging enabled, the local repository updates correctly with the statistics, but these do not get transferred to the Central repository.
By default, when installing the Central Repository, the option to update is set to update automatically after any LiteSpeed activity. This can be changed by rerunning Instance Configuration, so that the repository is updated via a scheduled job, or never.
To manually update the central repository, run the following command in SQL Query Analyzer against the local repository:
xp_replicate_activity_statistics
-OR-
double click the ActivityManager.exe
F5 to refresh the Enterprise Console screen to check the central repository for updates.
To reconfigure the central repository to update automatically, run the LiteSpeed Instance Configuration, available from the start menu, and follow through the install.
In the SQL Instances section select 'Install' on each instance. Then when you are at the Repository Update (Activity Statistics) screen, select the option to update 'Automatically after any LiteSpeed Activity'.
This will ensure that the central repository is updated automatically via the LiteSpeed2005 Activity Service the next time a LiteSpeed Backup is performed.
