Add database "Repair", "Recover", "Defrag", "Purge", "Compact", "Truncate" maintenance buttons in SCMU Management UI

Particular / ServiceControl

Backend for ServiceInsight and ServicePulse

https://docs.particular.net/servicecontrol/

Other

51 stars 47 forks source link

Add database "Repair", "Recover", "Defrag", "Purge", "Compact", "Truncate" maintenance buttons in SCMU Management UI #957

Open ramonsmits opened 7 years ago

ramonsmits commented 7 years ago

Our compacting and troubleshooting doco make use of the following tasks:

Repair: esentutl /p Data Recovery: esentutl /r RVN /l logs /s system Defrag / Compact: esentutl /d Data Purge: Purge all expired documents (nice after adjusting retention period) Truncate: Remove all data from the database. Would be similar as removing an instance including the files and reinstalling.

Having easy access to these tasks makes maintenance much easier.

WojcikMike commented 2 years ago

I believe that: #2311 is a subset of this issue

ramonsmits commented 2 years ago

@WojcikMike No, different issues. This is about maintenance tasks related to the database, the other issue is about repairing the "windows service" and queue setup.

dvdstelt commented 10 months ago

I agree this would be useful. People are sometimes afraid to run the tools. But we can also make it considerably easier for them when these buttons would do what the guidance mentions. Gives more trust even though we do the same thing.