WSS_Logging database

Truncate WSS_Logging database with this script :

1. Open SQL Server with "Run as Administrator"
2. Right click on WSS_Logging database & click on New Query.
3. Copy & paste below given script.

     DECLARE @TableName AS VARCHAR(MAX)

DECLARE table_cursor CURSOR
FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_NAME LIKE '%_Partition%'
OPEN table_cursor

FETCH NEXT FROM table_cursor INTO @TableName

WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @SQLText AS NVARCHAR(4000)

SET @SQLText = 'TRUNCATE TABLE ' + @TableName

EXEC sp_executeSQL @SQLText

FETCH NEXT FROM table_cursor INTO @TableName
END

CLOSE table_cursor
DEALLOCATE table_cursor

4. Run this query.

5. Than shrink this database.