Solved

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

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

Userlevel 6

+18

dbmaintenance -shrinkdb -N HistoryDB

Userlevel 6

+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

+18

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

Userlevel 7

+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

+12

CMR#321657

Userlevel 7

+23

Thank you, sir!

Userlevel 3

Hi,

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

Thanks,

Sign up