SQL Server2008 clearing the database log

M Miu 11:10:17

--' Here's dnname_log if you don't know what the name is in sys.database_files, you can query it with the following annotated statement
Use Dochuan
GO
SELECT file_id, name from Sys.database_files;
GO

--Start cleaning up
Use [master]
GO
ALTER DATABASE Dochuan SET RECOVERY simple with no_wait
ALTER DATABASE Dochuan SET RECOVERY Simple--Easy mode
GO
Use Dochuan
GO
DBCC shrinkfile (N ' Mall_jd_log ', 1, truncateonly)
GO

GO
ALTER DATABASE Dochuan SET RECOVERY full with no_wait
GO
ALTER DATABASE Dochuan SET RECOVERY Full--Revert to complete mode
GO

SQL Server2008 clearing the database log