SQL Server Performance Forum – Threads Archive
free db spacei deleted a huge table in db but db has the same size .
i shrink database but it just shrink a transaction log.
i still have 3 gb of free space
what should i do?
Did you drop the table or deleted all records in the same? If the table is empty, try dropping and recreating the same and then run shrink database (from backend and not enterprise manager) I have found it more effective from query analyzer (although I don’t have a scientific reason for it. [<img src=’/community/emoticons/emotion-4.gif’ alt=’‘ />]<br /><br />Cool Tip – If data recovery is not an issue, use TRUNCATE TABLE as it consumes less log and resets the space allocation for the table. [8D]<br /><br />Gaurav<br /><i>Moderator<br /><font size="1">Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard</i></font id="size1">
Try DBCC SRHINKFILE for the data file. It should do it. Bambola.
thank you i shrinked file it worked!