How to perform bulk delete and release free space?
0
votes
3
answers
1505
views
Good Afternoon,
We have a database that wasn't been an archive anytime. The database has grown tremendously and we are running short of space. Hence there is a need to do a bulk delete and free space. Based on my research, in order to free up space, I have 2 options: shrink DB or shrink files. The shrink DB is a bad option because it ruins the fragmentation. Can anyone guide me on how to perform a bulk delete and free space? Also, we are planning to implement this process on a monthly schedule job.
Based on the discussion, I want to clarify 3 things:
1. Bulk Delete Without Locking The Table
2. Reclaim Free Space
3. Schedule Monthly Job
Looking forward to expert opinion.
Asked by rushabh138
(13 rep)
Mar 8, 2021, 08:31 PM
Last activity: Mar 9, 2021, 04:26 PM
Last activity: Mar 9, 2021, 04:26 PM