Hello,

You can follow the below steps to Shrink the MSSQL database log file.

1. Log in to the windows server through RDP.
2. Open query analyzer.
3. Select the database as "Master".
4. Fire the below command :

HTML Code:
BACKUP LOG "DATABASE_NAME" WITH TRUNCATE_ONLY
You should now receive a success message.

5. Now change the database selected in query analyzer to "DATABASE_NAME" where DATABASE_NAME is the name of the database which is in question.

5. Now fire the below command :

HTML Code:
DBCC SHRINKFILE ('database-name_Log', 1)
where database-name_Log is the name of the log file of the db concerned. Such as test_Log. And the value '1' indicates the size that the log file needs to be shrunk to. This can be any value depending on the size of the log file of the db. This value is considered in MB's.


Regards,