数据库LOG文件压缩的语句
发表于 2014-04-08
Use DBNAME
GO
Alter Database DBNAME Set Recovery Simple
GO
Alter Database DBNAME Set Recovery Full
GO
DBCC SHRINKFILE (‘DBNAME_log’, 1)
GO
Use DBNAME
GO
Alter Database DBNAME Set Recovery Simple
GO
Alter Database DBNAME Set Recovery Full
GO
DBCC SHRINKFILE (‘DBNAME_log’, 1)
GO
