[备考] SQL2005 (及以上) - 清空数据库日志 

 1 USE [master]    
 2 GO    
 3 
 4 ALTER DATABASE [DBName] SET RECOVERY SIMPLE WITH NO_WAIT    
 5 GO    
 6 
 7 ALTER DATABASE [DBName] SET RECOVERY SIMPLE   --简单模式    
 8 GO    
 9 
10 USE [DBName]
11 GO    
12 
13  -- SELECT FILEID,GROUPID,NAME FROM SYSFILES WHERE GROUPID = 0
14 
15 DBCC SHRINKFILE (N'SLTDB_log' , 11, TRUNCATEONLY)    
16 GO    
17 
18 USE [master]    
19 GO     
20 
21 ALTER DATABASE [DBName] SET RECOVERY FULL WITH NO_WAIT     
22 GO     
23 
24 ALTER DATABASE [DBName] SET RECOVERY FULL  --还原为完全模式     
25 GO

 

posted on 2012-12-06 18:28  Diver Chan  阅读(256)  评论(0)    收藏  举报

导航