Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mathmax
Yak Posting Veteran
95 Posts |
 Posted - 2009-07-08 : 16:10:37
|
| Hello,When I drop some table from my database, the size of the .mdf file remains the same. Why ?I would like to be sure that my data have been deleted and cannot be recovered.Thank you in advance for any explanations.regards,mathmax |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2009-07-08 : 16:45:15
|
| The drop I believe only marks the pages as deleted...and leaves "empty" space in the datafile (mdf)....also...the data can be recovered from the log...You need to backup the database and the logThen shrink the database and shrink the datafilesBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
|
|
|
drop tables definitively