标题：SQL2008数据库如何收缩数据库文件

--SQL2008将日志文件收缩到指定的目标大小
--以下示例将 enjoy_store数据库中的日志文件收缩到 1 MB。
--若要允许 DBCC SHRINKFILE 命令收缩文件，首先需要通过将数据库恢复模式设置为 SIMPLE 来截断该文件。
USE [enjoy_shq];
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE [enjoy_shq]
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
USE [enjoy_shq]
DECLARE @LogFileLogicalName sysname
SELECT @LogFileLogicalName=Name FROM sys.database_files WHERE Type=1
PRINT @LogFileLogicalName
DBCC SHRINKFILE (@LogFileLogicalName, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE [enjoy_shq]
SET RECOVERY FULL;
GO