首页 > 数据库 > SQL Server > 正文

Sql Server 2008清理数据库日志的语句

2024-08-31 00:55:42
字体:
来源:转载
供稿:网友
Sql Server 2008清理数据库日志的语句USE [master]GOALTER DATABASE DNName SET RECOVERY SIMPLE WITH NO_WAITGOALTER DATABASE DNName SET RECOVERY SIMPLEGOUSE DNName GODBCC SHRINKFILE (N'LogFileName' , 0,TRUNCATEONLY)GOUSE [master]GOALTER DATABASE DNName SET RECOVERY FULL WITH NO_WAITGOALTER DATABASE DNName SET RECOVERY FULLGO
发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表