Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to reduce the size of Log files in SQL Server". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

First use [database name]; exec sp_helpfile

Use the sp_helpfile query to know the logical name of the log file, and then use DBCC to reduce the LOG file BACKUP LOG [database name] WITH TRUNCATE_ONLYdbcc shrinkfile ([logical name of the log file], 1).

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

The following methods should be taken:

The copy code is as follows:

-- first of all, change the recovery model of the database to SimpleALTER DATABASE [database name] SET RECOVERY SIMPLE;GO-- to reduce the log file to 1m, and the logical name can be obtained from DBCC SHRINKFILE through sp_helpfile ([log file logical name], 1). This is the end of the GO-- reset database recovery model ALTER DATABASE [database name] SET RECOVERY FULL;GO "how to reduce the size of Log files in SQL Server". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.