sqlserver2008 How to solve the LDF file too large

SQL2008 Empty Delete log:

' Clearing the log in SQL2008 must be done in simple mode, and then back to full mode when the cleanup is complete.

----------------------------------------------------------------

Use [master]
GO
ALTER database name SET RECOVERY simple with no_wait
GO
ALTER database name SET RECOVERY Simple--Easy mode
GO
Use database name
GO
DBCC shrinkfile (N ' database name _log ', one, truncateonly)

GO

' Database name _log If you don't know what the name is in sys.database_files, you can query it with the following annotated statement

' Use database name

' GO

' SELECT file_id, name from Sys.database_files;

' GO
Use [master]
GO
ALTER database name SET RECOVERY full with no_wait
GO
ALTER database name SET RECOVERY full--Revert to complete mode
GO

sqlserver2008 How to solve the LDF file too large