use DBName
DUMP TRANSACTION DBName WITH NO_LOG
BACKUP LOG DBName WITH NO_LOG
DBCC SHRINKFILE (DBName, 1);--收缩数据库
DBCC SHRINKFILE (DBName_Log, 1);--收缩日志
DUMP TRANSACTION DBName WITH NO_LOG
BACKUP LOG DBName WITH NO_LOG
DBCC SHRINKFILE (DBName, 1);--收缩数据库
DBCC SHRINKFILE (DBName_Log, 1);--收缩日志