SQL2008R2【ICCO】——日志清除
USE [master]
GO
ALTER DATABASE icco SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE ICCO
SET RECOVERY SIMPLE
GO
USE ICCO
GO
DBCC SHRINKFILE (N‘iCCO_log‘ , 0,TRUNCATEONLY)
GO
USE [master]
GO
ALTER DATABASE ICCO SET RECOVERY FULL WITH NO_WAIT
GO
ALTER DATABASE ICCO SET RECOVERY FULL
GO
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/16041.html
