数据库收缩(<sql2008)

use  [master]         -----------修改master为你的数据库


DECLARE @dbname VARCHAR(60)
SELECT @dbname = CONVERT(VARCHAR(60), DB_NAME())
exec('DUMP TRANSACTION ['+@dbname+'] WITH  NO_LOG') 
DECLARE @logname VARCHAR(60) 
SELECT  @logname = rtrim(ltrim(name))
    FROM  sysfiles
    WHERE name LIKE '%log%' 
exec('BACKUP LOG ['+@dbname+'] WITH NO_LOG')
exec  ('DBCC SHRINKFILE(['+@logname+'],1)')