SQL Log File

Solution

To Shrink the LOG file (LDF) please run the following command in your SQL Server

you have to check the log file name in the database properties and enter the same in this command. In the sample Log file name is TimeTrack_log

sample

ALTER DATABASE TimeTrack SET RECOVERY SIMPLE WITH NO_WAIT

DBCC SHRINKFILE(TimeTrack_log, 1)

ALTER DATABASE TimeTrack SET RECOVERY FULL WITH NO_WAIT

Was this article helpful? yes / no

Article details