A compressed MS SQL Server log statement _mssql

Copy Code code as follows:

--====================================================================
--SQL: Database compression statements
----------------------------------------------------------------------
--Description: compressing the database

--Modify:x.zhong
--====================================================================
DECLARE @db_name varchar (200)

--Get the current database name
Declare getdbname cursor FOR select db_name ()
Open Getdbname
Fetch getdbname into @db_name
While @ @fetch_status = 0
Begin
Fetch getdbname into @db_name
End
Close Getdbname
Deallocate Getdbname

--Compressing database logs
DUMP TRANSACTION @db_name with no_log
BACKUP LOG @db_name with no_log
DBCC Shrinkdatabase (@db_name)