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:
- Got to the SQL Server Management Studio
- Right Click on the Database
- Select Properties
- Select Options menu
- Here Recovery model was showing “Full”.
- Changed this to “Simple” and press OK.
Run below Query:
ALTER Database <DBName> SET Recovery Simple
Again shrink the database. Now db size reduced to 150 MB.