MSSQL日志清理

USE RYAccountsDB
ALTER DATABASE RYAccountsDB SET RECOVERY SIMPLE WITH NO_WAIT
ALTER DATABASE RYAccountsDB SET RECOVERY SIMPLE 
USE RYAccountsDB
DBCC SHRINKFILE(N'RYAccountsDB_log',0,TRUNCATEONLY)
ALTER DATABASE RYAccountsDB SET RECOVERY FULL WITH NO_WAIT
ALTER DATABASE RYAccountsDB SET RECOVERY FULL



USE RYTreasureDB
ALTER DATABASE RYTreasureDB SET RECOVERY SIMPLE WITH NO_WAIT
ALTER DATABASE RYTreasureDB SET RECOVERY SIMPLE 
USE RYTreasureDB
DBCC SHRINKFILE(N'RYTreasureDB_log',0,TRUNCATEONLY)
ALTER DATABASE RYTreasureDB SET RECOVERY FULL WITH NO_WAIT
ALTER DATABASE RYTreasureDB SET RECOVERY FULL