USE 數(shù)據(jù)庫(kù)名
GO
SELECT file_id, name,size,* FROM sys.database_files;

USE [master]
GO
ALTER DATABASE 數(shù)據(jù)庫(kù)名 SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE 數(shù)據(jù)庫(kù)名 SET RECOVERY SIMPLE --簡(jiǎn)單模式
GO
USE 數(shù)據(jù)庫(kù)名 
GO
DBCC SHRINKFILE (N'文件名' , 11, TRUNCATEONLY) 
GO
USE [master]
GO
ALTER DATABASE 數(shù)據(jù)庫(kù)名 SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE 數(shù)據(jù)庫(kù)名 SET RECOVERY FULL --還原為完全模式
GO