freeing up space | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

freeing up space

Hey guys, I have deleted the tables using EM but the size of the .MDF is still the same. How do I free up space? Thanks, V1rt
You would need to shrink the database. If you’re using EM, you can do this via em. Right click on the database and pick shrink. Look at BOL for shrink on how to do it via QA. Chris
Thank you. It worked