3use [master]
go
ALTER DATABASE [kl_ztuc_cn] SET RECOVERY SIMPLE WITH NO_WAIT
go
ALTER DATABASE [kl_ztuc_cn] SET RECOVERY SIMPLE
go
ALTER DATABASE [kl_ztuc_cn] SET RECOVERY SIMPLE
go
use [kl_ztuc_cn]
go
--以下一行查询XXX_log
--SELECT file_id, name FROM sys.database_files;
--go
DBCC SHRINKFILE (N’xk_six_caiji_Log’ , 0,TRUNCATEONLY)
go
use [kl_ztuc_cn]
go
ALTER DATABASE [kl_ztuc_cn] SET RECOVERY FULL WITH NO_WAIT
go
ALTER DATABASE [kl_ztuc_cn] SET RECOVERY FULL
go
use [kl_ztuc_cn]
go
use [kl_ztuc_cn]
go
SELECT name FROM SYS.database_files WHERE type_desc=’LOG’例：控制表格内容样式：