USE [master]--把数据库调整为简单模式GOALTER DATABASE krisvision SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE krisvision SET RECOVERY SIMPLE --简单模式GO--收缩数据库文件USE krisvisionGODBCC SHRINKFILE (N‘krisvision_Song_Log‘ , 11, TRUNCATEONLY)GOUSE [master]GO--把数据库调整成完整模式ALTER DATABASE krisvision SET RECOVERY FULL WITH NO_WAITGOALTER DATABASE krisvision SET RECOVERY FULL --还原为完全模式GO--查询日志文件名称--SELECT file_id, name FROM sys.database_files;

来源:
http://www.jb51.net/article/37305.htm