Can someone recommend how to fix this without going into SQL management studio?
Best answer by MFasulo 1 July 2021, 20:03
dbmaintenance -shrinkdb -N HistoryDB
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.
It’s in Full Recovery Model, is it being protected by a SQL iDA?
@MFasulo , did you enter an MR for this? If so, let me know the CMR number so I can add itto this thread.
Thank you, sir!
DB Maintenance Workflow on Cloud already has this feature built-in
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.