Skip to main content
Answer

How do I shrink the historyDB? Flagged critical on my health scorecard

  • June 18, 2021
  • 7 replies
  • 729 views

MFasulo
Vaulter
Forum|alt.badge.img+11

Can someone recommend how to fix this without going into SQL management studio?

 

 

Best answer by MFasulo

CMR#321657

7 replies

Scott Moseman
Vaulter
Forum|alt.badge.img+18

dbmaintenance -shrinkdb -N HistoryDB
 


MFasulo
Vaulter
Forum|alt.badge.img+11
  • Author
  • Vaulter
  • June 18, 2021

Better… that took the log down to 6gb.   Shrink log in SQL took it down to 1mb.  

Need a CMR to get a DB dropdown in the DB maintenance workflow.


Scott Moseman
Vaulter
Forum|alt.badge.img+18

It’s in Full Recovery Model, is it being protected by a SQL iDA?
 


Mike Struening
Vaulter
Forum|alt.badge.img+22

@MFasulo , did you enter an MR for this?  If so, let me know the CMR number so I can add itto this thread.


MFasulo
Vaulter
Forum|alt.badge.img+11
  • Author
  • Vaulter
  • Answer
  • July 1, 2021

CMR#321657


Mike Struening
Vaulter
Forum|alt.badge.img+22

Thank you, sir!


Forum|alt.badge.img+5
  • Vaulter
  • July 2, 2021

Hi,

DB Maintenance Workflow on Cloud already has this feature built-in 

https://cloud.commvault.com/webconsole/softwarestore/#!/136/671/12067

 

Thanks,