SQL Express compress MDF file

Ive been doing a lot of work in aspx on a mdf file, and now its empty, but showing as 6Gb in size.

Is there a command I can issue to compact the database, or is it a case of deleting it and starting again with an empty mdf file?

Any help would be appriciated.

Thank you
tonelm54Asked:
Who is Participating?
 
tonelm54Author Commented:
Just for future users wanting to know, I found this to work really well as a command

DBCC SHRINKDATABASE ("C:\Documents and Settings\App_Data\Database.mdf")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.