Hi experts,
I have a 3+ TB database on a 2019 sql server which has more than 50% free space. I know database or data file shrink is not a good practice so please not go there, I tried with 100 mb in a loop which is taking much longer time so it's not feasible.
Any suggestion BESIDES creating a new .ndf file ad then emptying the mdf file into the new file and then remove etc...
Thanks in advance.
- This topic was modified 59 minutes ago by Tac11.