Member Avatar for xirosen

Our server growth is too fast from 30GB from last month now it reaches into 50GB. Is their a problem in our database? Can this be possible to shrink this database into a minimal Size?

Our server is MS SQL server 2000.

  • 2 Contributors
  • 1 Reply
  • 138 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by pclfw
Member Avatar for pclfw

In Enterprise Manager highlight the database name, right click and chose VIEW > TASKPAD. This will show if there is any free space and where it is. You might want to make notes of the amount of free space and file sizes too.

You can then chose to right click on the DB name again chose ALLTASKS and SHRINK DATABASE. Click on the option to move the pages to the beginning of the file. Be aware that this will impact the performance of the shrink. Be prepared to wait a number of hours for this to run.

Now start figuring out WHY your DB ballooned so quickly.

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.