sql語(yǔ)句給數(shù)據(jù)庫(kù)減肥，下面以網(wǎng)狐6603數(shù)據(jù)庫(kù)減肥腳本

網(wǎng)狐6603 專用數(shù)據(jù)庫(kù)減肥特效腳本(18G變成300M)如下：

將腳本語(yǔ)句復(fù)制到sql server 新建查詢中，執(zhí)行即可，可以清楚冗余的日志

/*
* 數(shù)據(jù)庫(kù)超級(jí)減肥, 18G可變成300M.

*/

-- Truncate the log by changing the database recovery model to SIMPLE.
use qptreasuredb
ALTER DATABASE qptreasuredb
SET RECOVERY SIMPLE
GO
-- Shrink the truncated log file to 1 MB. 收縮日志文件大小(單位是M)
DBCC SHRINKFILE (qptreasuredb_log, 1)
GO
-- Reset the database recovery model.
ALTER DATABASE qptreasuredb
SET RECOVERY FULL

use qprecorddb
ALTER DATABASE qprecorddb
SET RECOVERY SIMPLE
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (qprecorddb_log, 1)
GO
-- Reset the database recovery model.
ALTER DATABASE qprecorddb
SET RECOVERY FULL

use qpaccountsdb
ALTER DATABASE qpaccountsdb
SET RECOVERY SIMPLE
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (qpaccountsdb_log, 1)
GO
-- Reset the database recovery model.
ALTER DATABASE qpaccountsdb
SET RECOVERY FULL
GO

use QPEducateDB
ALTER DATABASE QPEducateDB
SET RECOVERY SIMPLE
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (QPEducateDB_log, 1)
GO
-- Reset the database recovery model.
ALTER DATABASE QPEducateDB
SET RECOVERY FULL
go
select * from sys.database_files --查找數(shù)據(jù)庫(kù)log文件邏輯名

更多知識(shí)點(diǎn)可見(jiàn)×××××× www.yasewl.com