Statement for compressing ms SQL Server logs

CopyCodeThe Code is as follows: -- ===================================================== ==================================
-- SQL: Database compression statement
----------------------------------------------------------------------
-- Description: compresses the database.

-- Modify: X. Zhong
-- ===================================================== ==================================
Declare @ db_name varchar (200)

-- Get the name of the current database
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

-- Compress database logs
Dump transaction @ db_name with no_log
Backup log @ db_name with no_log
DBCC shrinkdatabase (@ db_name)