重建数据库日志

 1 USE [master]
 2 GO
 3 
 4 ALTER DATABASE 数据库名称 SET RECOVERY SIMPLE WITH NO_WAIT
 5 GO
 6 
 7 ALTER DATABASE 数据库名称 SET RECOVERY SIMPLE
 8 GO
 9 
10 USE 数据库名称
11 GO
12 
13 declare @dbName nvarchar(100)
14 
15 set @dbName = (SLEECT name FROM sys.database_files WHERE type=1)
16 GO
17 
18 DBCC SHRINKFILE(@dbName,1,TRUNCATEONLY)
19 GO
20 
21 USE [master]
22 GO
23 
24 ALTER DATABASE 数据库名称 SET RECOVERY FULL WITH NO_WAIT
25 GO
26 
27 ALTER DATABASE 数据库名称 SET RECOVERY FULL