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