Ways to reduce log file size in SQL Server share _mssql

First of all
Use [database name];
exec sp_helpfile;

Use the sp_helpfile query to know the logical name of the log file, and then you can use DBCC to reduce the log file
BACKUP LOG [database name] WITH TRUNCATE_ONLY
DBCC SHRINKFILE (logical name of log file],1)

This method is no longer applicable in MS SQL Server 2008 and MS SQL Server 2008 R2, prompting: TRUNCATE_ONLY is not a valid BACKUP option.

This should be done in the following ways:

Copy Code code as follows:

--First change the recovery mode of the database to simple
ALTER database [database name] SET RECOVERY simple;
Go
--Reduce log file to 1M, logical name can be obtained by sp_helpfile
DBCC shrinkfile ([log file logical name], 1);
Go
--Reset the recovery model for the database
ALTER DB [database name] SET RECOVERY full;
Go