Easy Steps to Your Shrink SQL Database Log

Hi Folks,

Today we are going see to how to Shrink your MS SQL Database log file.

This article requires the use of Microsoft SQL Server Management Studio. If you do not have this installed, Microsoft SQL Server Management Studio Express is available for free from Microsoft

Now let’s see how to do it.

Before that first you have change MS SQL database recovery model to simple

  1. Log into Microsoft SQL Server Management Studio
  2. Right Click on your Database
  3. Then choose Properties
  4. Change the recovery model to Simple
  5. Then Click OK
  6. Once you changed recovery
  7. Right click on the database
  8. Select Tasks > Shrink > Database
  9. Click OK
  10. Now you have change the recovery model to Full. Right click on the database
  11. Select Properties
  12. Click on Options
  13. Change the recovery model to Full
  14. Click OK

Finally Restart your database service

Hope this tutorial will be helpful 🙂


View all posts by