Activity overview
Latest activity by VTDBA
Scripting Creation of SDC project
Hi - we are moving from SSIS projects for our ETL to SQL Data compare. Due to the large number of tables and keys involved, we create our SSIS packages using C# and the Microsoft.SqlServer.Dts obj...
Ok - so here is a solution that worked for us if you don't want to lose your history or data. Follow Alex B.'s instructions above, except with some differences - we are going to keep the data and ditch the indexes, forcing DLM Dashboard to rebuild the corrupted indexes. -Open your services panel and stop all three DLM Dashboard services (DLM Dashboard Monitoring Service, DLM Dashboard Storage Service, and DLM Dashboard Web Server) -Go to C:\ProgramData\Red Gate\SQL Lighthouse\ -Go to the RavenDB folder and delete the following folders: 1) CompiledIndexCache 2) IndexDefinitions 3) Indexes -Open your services panel and start all three DLM Dashboard services (DLM Dashboard Monitoring Service, DLM Dashboard Storage Service, and DLM Dashboard Web Server) -Browse to the DLM home page. It will show the same message from before "DLM Dashboard is just starting up" - but this time it's actually rebuilding the missing indexes. Be patient - depending on the size of your Raven DB it could take a few minutes. Ours was 1.4 gigs, and it took about 3 minutes. -You should end up with your DLM Dashboard fully working again, without having to rebuild. / comments
Ok - so here is a solution that worked for us if you don't want to lose your history or data.Follow Alex B.'s instructions above, except with some differences - we are going to keep the data and di...