Trying to shrink an MDF's file size, using SQL Express 2008

I detached a database and found it to be 150MB and the log file to be 500MB. I re-attached it, modified my deletion script, and deleted ober 100K records. When I saw there were only a few dozzen rrecords remaining, I detached the database. but I saw it's size did not drop.

How do I get it to "compact itself"? I need this to be small since it would contain the schem for 10 tables, most of which are empty.

Thanks,
newbieweb
newbiewebSr. Software EngineerAsked:
Who is Participating?
 
r_panosCommented:
Follow the instructions of
http://msdn.microsoft.com/en-us/library/ms189035.aspx

or execute
DBCC SHRINKDATABASE 
( database_name | database_id | 0 
     [ ,target_percent ] 
     [ , { NOTRUNCATE | TRUNCATEONLY } ] 
)DBCC SHRINKDATABASE 
( database_name | database_id | 0 
     [ ,target_percent ] 
     [ , { NOTRUNCATE | TRUNCATEONLY } ] 
)
[ WITH NO_INFOMSGS ]
[ WITH NO_INFOMSGS ]

Open in new window

0
 
ylarvorCommented:
hello, detacher is meaning shrink in french, you can choose to shrink the database or the log file...
shrink.png
0
 
newbiewebSr. Software EngineerAuthor Commented:
Thanks.
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.