SQL Server2008ldf文件太大
--适用于SQL Server 2008的方法 USE [master] GO ALTER DATABASE RmyyHisDW SET RECOVERY SIMPLE WITH NO_WAIT GO ALTER DATABASE RmyyHisDW SET RECOVERY SIMPLE --简单模式 GO USE RmyyHisDW GO DBCC SHRINKFILE (N'RmyyHisDW_Log' , 11, TRUNCATEONLY) GO USE [master] GO ALTER DATABASE RmyyHisDW SET RECOVERY FULL WITH NO_WAIT GO ALTER DATABASE RmyyHisDW SET RECOVERY FULL --还原为完全模式 GO