时间:2021-07-01 10:21:17 帮助过:18人阅读
sql2008,sql2012清空日志语句
ALTER DATABASE DbName SET RECOVERY SIMPLE WITH NO_WAIT ALTER DATABASE DbName SET RECOVERY SIMPLE DBCC SHRINKFILE (N‘DbName_Log‘ , 11, TRUNCATEONLY) ALTER DATABASE DbName SET RECOVERY FULL WITH NO_WAIT ALTER DATABASE DbName SET RECOVERY FULL
sql2005,sql2008,sql2012清空日志语句
标签: