In order to shrink the Database, follow the below steps.
1. Take a Full back up of your current database using SSMS (SQL Server Management Studio)
2. Log in as System Administrator (SA). Expand your Databases folder. Right click on your database, select Tasks, Select Backup to perform a Full Backup.
3. Select New Query window from SSMS, or use shortcut CTRL + N
4. Run the below query with your database name.
USE YOUR_DATABASE;
GO
—– Truncate the log, change the recovery model to SIMPLE.
ALTER DATABASE YOUR_DATABASE
SET RECOVERY SIMPLE;
GO
—– Shrink the truncated log file to 500 MB.
DBCC SHRINKFILE (YOUR_DATABASE_Log, 500);
GO
—– Change the database recovery model.
ALTER DATABASE YOUR_DATABASE
SET RECOVERY FULL;
GO
Replace the text YOUR_DATABASE with your database Name.
Before you run the query, make sure to verify the log file name with your database log file.