DECLARE @name NVARCHAR(50)--数据库名
DECLARE @logname NVARCHAR(50)--数据库名
USE IUP_2009_10_25
SET @name=N'IUP_2009_10_25'
SET @logname=@name + N'_log'
print @name
print @logname
--1.清空日志
DUMP TRANSACTION @name WITH NO_LOG
--2.截断事务日志:
BACKUP LOG @name WITH NO_LOG
--3.收缩数据库文件
DBCC SHRINKFILE (@logname , 0, TRUNCATEONLY)
--分离数据库
USE [master]
EXEC master.dbo.sp_detach_db @dbname = @name, @keepfulltextindexfile=N'true'