Where are the Change Acknowledgements stored?

nate_the_dba

Simple question: where & how are the DLM change-acknowledgement messages stored? For example, if I'm uninstalling DLM Dashboard from my workstation and re-installing it, will all the previous change ack history be preserved somewhere in a database? Is it on each monitored instance's RedGate DB? Or what? Thanks!

Jessica R

Hi and thanks for your post!

The data is stored in a RavenDB database and its files are located in C:ProgramDataRed GateSQL Lighthouse (this remains through reinstalls).

You can view the RavenDB content through the studio on http://localhost:21060 (it uses Silverlight so it needs to be viewed from IE). The approval comments in particular are stored in the Approvals document.

Hope that info helps!

nate_the_dba

Thanks! To readers: Jessica is an awesome support agent, FYI!

DBAonRoute

Excellent, Just what I needed to know. Cheers 

dplaut

I get a window telling me to install Silverlight but it is already installed. Uninstalling and reinstalling made no difference.