Shulou(Shulou.com)06/01 Report--

-- instructions for use

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

-- HDocsN_Log is the name of the log file to be cleared

-- change all HDocsN you see to the name of the database to be cleared

-- modify the log file name of all cleared databases for HDocsN_Log

-- this name is the response database xxx_log file where the local database is located

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 (NumberHDocs Native Log', 200, TRUNCATEONLY)

USE [master]

GO

ALTER DATABASE HDocsN SET RECOVERY FULL WITH NO_WAIT

GO

ALTER DATABASE HDocsN SET RECOVERY FULL-revert to full mode

GO

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.