Member Avatar for xirosen

Hi,,, we have a database grown too fast... from 19GB last march 09 into 52GB this Nov 09... I search through internet on what happen why do database grow fast and i find nothing,, i found out on how to "sp_spaceused" query and the result says:

database_name database_size unallocated space
MPSDB 52808.63 MB 4248.71 MB

reserved data index_size unused
49589288 KB 6859920 KB 2001880 KB 40727488 KB

My question is: is there's a way on how to use the unused bytes/allocation or can we remove those whitespaces to gain more space in our HD drive?

Help pls... i'm begging you all geniuses to pls help me.. tnx

  • 2 Contributors
  • 1 Reply
  • 69 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by GrimJack
Member Avatar for GrimJack

take a look here and see if it addresses your problem

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.