Sample Header Ad - 728x90

SQL Server does not reduce the size of MDF and LDF files even though the file shrink process has been carried out

-1 votes
1 answer
74 views
I am a SQL Server 2017 user, I deleted a table that had too many records, but after the delete process, the size of the MDF and LDF files did not decrease, but increased. I have shrunk the file but the file size remains the same. What should I do to change the file size? I want the mdf file size to return to normal according to the existing record
Asked by Rafardhan Athalla (1 rep)
Mar 14, 2025, 09:55 AM
Last activity: Mar 14, 2025, 08:57 PM