In sql server, we can shrink database like this,
1. Open Microsoft SQL Server Management Studio
2. Right click on your database.
3. Select Properties.
4. Click on Options.
5. Change the recovery model to Simple.
6. Click OK.
7. Right click on the database.
8. Select Tasks > Shrink > Database.
9. Click OK.
10. Right click on the database.
11. Select Properties.
12. Click on Options.
13. Change the recovery model to Full.
14. Click OK.
(or)
ALTER DATABASE MyDB SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (MyDB_Log, 10)
GO
ALTER DATABASE MyDB SET RECOVERY FULL
GO