SQL Server 2008 emptying the delete log file

--Instructions for use

--HDOCSN is the name of the database to be modified

--hdocsn_log is the name of the log file to be purged

--Modify all the HDOCSN you see as the name of the database to be purged

--Modify the log file name of Hdocsn_log for all purged databases

--This name is the response database Xxx_log file where the local database resides

GO

Use[master]

GO

ALTER DATABASE HDOCSN SET RECOVERY simple with no_wait

GO

ALTER DATABASE HDOCSN SET RECOVERY simple--Simple Mode

GO

Use HDOCSN

GO

DBCC shrinkfile (N ' Hdocsn_log ', $, truncateonly)

Use[master]

GO

ALTER DATABASE HDOCSN SET RECOVERY full with no_wait

GO

ALTER DATABASE HDOCSN SET RECOVERY Full--Revert to complete mode

GO

This article is from the "Stay Traveler" blog, please make sure to keep this source http://2476177.blog.51cto.com/2466177/1854822

SQL Server 2008 emptying the delete log file