ID #1810

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.

.

Tags: Database, size

Related entries:

You cannot comment on this entry