Can't able to get back deleted table space from sql server 2012 database .

Hi ...

I have one sql server 2012 database, and it's size is near about 64 GB

i had deleted unwanted tables which are near about 30 GB size .
but , still my database have 64 GB size.
If i am taking full backup of database then it is 34 GB.
I had restarted server, also rebuilds all tables indexes , but still my database size is 64 GB ,
can any one tell me how can i get back deleted tables size from my database.
It's mdf file size.
i had shrink   Log file size,
Ashvin AjagiyaDatabase AdministratorAsked:
Who is Participating?
 
Vikas GargConnect With a Mentor Business Intelligence DeveloperCommented:
SQL will not free the unused space after deleting data but will insert new data in that place so the size is not reducing without shrinking the MDF file.

You have to shrink the mdf file if you want the free size back but this will lead to fragmentation which you can overcome by rebuilding Indexes.

Hope this would help you.
0
 
Dung DinhConnect With a Mentor DBA and Business Intelligence DeveloperCommented:
Hi,

Shrinking file is not recommend idea because it cause fragmentation of data. I recommend that you rebuild indexes and move to new data files.

Thanks,
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can you run the following command and post here the result?
sp_helpdb YourDatabaseNameHere

Open in new window

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.