SQL statement to the database weight loss, below to net Fox 6603 database weight loss Script

NET Fox 6603 Special Database Weight Loss effect script (18G into 300M) is as follows:

Copy script statements to SQL Server new query, execute, clear redundant log

/*
* Database Super Weight loss, 18G can become 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. Shrink log file size (in units of 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--Find the logical name of the database log file

More knowledge points can be seen chess source building www.yasewl.com

This article is from the "Chess Card source Building Tutorial" blog, please be sure to keep this source http://13152879.blog.51cto.com/13142879/1949781

SQL statement to the database weight loss, below to net Fox 6603 database weight loss Script