RanceLab

Find answers to common RanceLab questions, browse curated FAQ sections, and search across the knowledge base.

FAQ
Settings
/Database Mantinance
/SQL Server

What shall I do if database size does not reduce after shrinking?

Scenario:

Today I was working on a Database. I found that DB size is showing approx 8 GB. There were no such huge transactions in that database (approx 15000 Sale and 5000 Purchase bills only). I checked the .mdf and .ldf file and found that Log file is taking up to 7.8 GB size. Then I run Shrink Database but DB size did not reduce.

Then I follow the below steps:

Option 1:

  1. Got to the SQL Server Management Studio
  2. Right Click on the Database
  3. Select Properties
  4. Select Options menu
  5. Here Recovery model was showing “Full”.
  6. Changed this to “Simple” and press OK.

Option 2:

Run below Query:

ALTER Database <DBName> SET Recovery Simple

Again shrink the database. Now db size reduced to 150 MB.

.