Forgive me, but I am very new to being a DBA as I ended up in this role out of necessity :)
I am currently working on reducing the size of several databases. I previously asked a question here about how to accomplish this, and I used the DBCC Shrinkfile command. It worked fine for my first database, as the file size was significantly reduced. However, when I moved on to the second database that needs its file size reduced, the DBCC Shrinkfile query has been running over the weekend and still hasn't finished. Did I do something wrong?
I have tested the DBCC Shrinkfile command on this database before, and even reducing just 10MB took about 10 or 20 minutes. Am I missing something? Is there something I should do beforehand?
- The size of the database I'm trying to reduce is 1.78TB (I set the query to reduce it to 1TB) with 55% free space.
- I have set the recovery model to Simple.
- Link to my previous question
- SQL Server & SSMS 2017
- The server is on a VM, 8 core cpu Xeon e5, 24GB ram, and its running on hard disk.