[sql-server] How do I shrink my SQL Server Database?

I think you can remove all your log with switch from full to simple recovery. Right click on your Database and select Properties and select Options and change

  • Recovery mode to Simple
  • Containment type to None

Switching from full to simple