delet database but still fixed space

Question

Post reply

delet database but still fixed space

hodhod26

Mr or Mrs. 500

Points: 515
More actions
July 28, 2009 at 7:33 am

#99789

hi all i delet some tables from my database but the space of MDF is still the same.how can i reduce the size of MDF.:w00t:

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ken Simmons SSCertifiable Points: 7822 More actions · Answer 1

You have to shrink the file to reclaim the space. See the following link...

http://msdn.microsoft.com/en-us/library/aa258824(SQL.80).aspx

ps. One Orange Chip Points: 29422 More actions · Answer 2

if you're sure the database wont grow to its original size in near future, you can proceed with shrinking or else leave it at that size as it'll eventually grow to that size...

Pradeep Singh

hodhod26 Mr or Mrs. 500 Points: 515 More actions · Answer 3

i delet the data base because i need to use this space there is no enough space in the disk.

hodhod26 Mr or Mrs. 500 Points: 515 More actions · Answer 4

hodhod26

Mr or Mrs. 500

Points: 515

July 28, 2009 at 10:57 am

#1031177

thanks all shrink solve the proble,:-D