Sponser Link

SQL Server reduce size of log file

SQL log file is used for record all type of change in database and keep transactional cache for internal use. It is use for different types of recovery for example transaction recovery , transitional replicas and internal management. If you want to reduce the size of log file then you can do also using query. Syntax is given below. 

ALTER DATABASE DATBASE_NAME
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (LOG_FILE_NAME_log, size in MB)
GO
ALTER DATABASE DATBASE_NAME
SET RECOVERY FULL

You can find the log file name using right click on database.

SQL Server Log File Loation

Complete example is given below. 


ALTER DATABASE db5
SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE (adb5_log,10)
GO
ALTER DATABASE db5
SET RECOVERY FULL