sql server 2008日志清理

use master

go

alter database FDAYSRealShop set recovery simple with no_wait

go

alter database FDAYSRealShop set recovery simple

go

use FDAYSRealShop

go

 DBCC SHRINKFILE (N'FDAYSRealShop_Log' , 1, TRUNCATEONLY)

 go

 

 USE master

go

alter database FDAYSRealShop set recovery simple with no_wait

go

alter database FDAYSRealShop set recovery simple

go

posted @ 2011-06-01 15:31  俗雅冰山  阅读(216)  评论(0)  编辑  收藏  举报