如何使用sql語句使你的資料庫減肥，下面以網狐6603資料庫減肥指令碼舉例！

標籤：

原文轉自：http://www.zccode.com/forum.php?mod=viewthread&tid=637&extra=page%3D1

 

網狐6603 專用資料庫減肥特效指令碼(18G變成300M)如下：

將指令碼語句複製到sql server 建立查詢中，執行即可，可以清楚冗餘的日誌

 

/*
* 資料庫超級減肥, 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 --尋找資料庫log檔案邏輯名

如何使用sql語句使你的資料庫減肥，下面以網狐6603資料庫減肥指令碼舉例！