首页 > 代码库 > Transaction Log Truncation

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 = NC:\aa.bak --BACKUP LOG KIS_Sample TO DISK = ‘nul:‘ WITH STATS = 10 DBCC SHRINKFILE (KISPro100_log, 1)

 

Transaction Log Truncation