SQL Server mdf file too large I have a .mdf file that is 10gb. This is the max file size. How can I reduce the file size? I do not need the data, I just need to be able to write new data to the database.

I have deleted a ton of rows, but the file size has not changed at all.

Any help would be appreciated!

Also, my log file grew by about 50gb when I deleted the rows from the .mdf. How do I make that smaller as well?
You have to shrink database so the deleting the data takes place
Right Click on your database , Tasks => Shrink => Files
In shrink action choose the second Option and enter your file ideal size
You're done
:)