Transaction Log Truncation

 

 

--method 1--
ALTER DATABASE KIS_Sample3 SET RECOVERY SIMPLE
 DBCC SHRINKFILE (KISPro100_log, 1)
 ALTER DATABASE KIS_Sample3 SET RECOVERY full
  go
 
 --metohd 2--
 use KIS_Sample
 go
 BACKUP DATABASE KIS_Sample TO DISK = N'C:\aa.bak'
 --BACKUP LOG KIS_Sample TO DISK = 'nul:' WITH STATS = 10
 DBCC SHRINKFILE (KISPro100_log, 1)

 

posted @ 2014-09-23 10:50  zyip  阅读(113)  评论(0)  编辑  收藏  举报