Solved

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

  • 18 June 2021
  • 7 replies
  • 503 views

Userlevel 6
Badge +12

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

 

 

icon

Best answer by MFasulo 1 July 2021, 20:03

View original

7 replies

Userlevel 6
Badge +17

dbmaintenance -shrinkdb -N HistoryDB
 

Userlevel 6
Badge +12

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.

Userlevel 6
Badge +17

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

Userlevel 7
Badge +23

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

Userlevel 6
Badge +12

CMR#321657

Userlevel 7
Badge +23

Thank you, sir!

Userlevel 3
Badge +6

Hi,

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

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

 

Thanks,

 

Reply