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

The main content of this article is to explain "what is the method of log cleaning of AM8 database in SQLserver 2008 environment". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "what is the method of cleaning AM8 database log in SQLserver 2008 environment"?

-- AM's database is AM8. Before cleaning up the AM8 database, change the following [database name] to [AM8] and change the 'database log file name' to 'AM8_log''.

-- 1) query the specified database through the following sql statement, and replace it with the above sql

USE [database name]

GO

SELECT name FROM SYS.database_files WHERE type_desc='LOG'

-2) formally carry out the clean-up

USE [master]

GO

ALTER DATABASE [database name] SET RECOVERY SIMPLE WITH NO_WAIT

GO

ALTER DATABASE [database name] SET RECOVERY SIMPLE

GO

USE [database name]

GO

DBCC SHRINKFILE (N' database log file name', 0 truncation)

GO

USE [master]

GO

ALTER DATABASE [database name] SET RECOVERY FULL WITH NO_WAIT

GO

ALTER DATABASE [database name] SET RECOVERY FULL

GO

At this point, I believe that everyone on the "SQLserver 2008 environment AM8 database log cleaning method is what" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.