WSUS auf Server 2016 - Datenbank bereinigen?

@echo off 

set TOOLPATH=D:\WSUS-Tools\WSUS-CleanUp
set WSUS-SERVER=MeinServer
set PORT-NUMBER=8530
set DATABASECONNECT=np:\\.\pipe\MSSQL$SQLEXPRESS\sql\query
set SQLCMD="C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\SQLCMD.EXE"  

set LOG=%TOOLPATH%\WSUS-CleanUp.log
set CLEANUPSCRIPT=%TOOLPATH%\WSUS-Serverbereinigung.ps1
set SQLSCRIPT=%TOOLPATH%\WsusDBMaintenance.sql

echo.> "%LOG%"  
echo Start der Datenbankbereinigung: %DATE% um %TIME% Uhr>> "%LOG%"  
echo =============================================================>> "%LOG%"  
echo.>> "%LOG%"  
echo Cleanup Report für [%WSUS-SERVER%] (Port: %PORT-NUMBER%)>> "%LOG%"  
echo ------------------------------------------------------------->> "%LOG%"  
REM "%SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe" Set-ExecutionPolicy Remotesigned  
"%SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe" "%CLEANUPSCRIPT%" %WSUS-SERVER% %PORT-NUMBER%>> "%LOG%"  
echo ------------------------------------------------------------->> "%LOG%"  
echo Ende Dateibereinigung: %DATE% um %TIME% Uhr>> "%LOG%"  
echo.>> "%LOG%"  
echo SQL Server Wartung (Connect %DATABASECONNECT%)>> "%LOG%"  
echo ------------------------------------------------------------->> "%LOG%"  
%SQLCMD% -I -S %DATABASECONNECT% -i %SQLSCRIPT%>> "%LOG%"  
%SQLCMD% -I -S %DATABASECONNECT% -dSUSDB -Q "DBCC SHRINKDATABASE(N'SUSDB' )">> "%LOG%"  
%SQLCMD% -I -S %DATABASECONNECT% -dSUSDB -Q "DBCC SHRINKFILE (N'SUSDB' , 0, TRUNCATEONLY)">> "%LOG%"  
%SQLCMD% -I -S %DATABASECONNECT% -dSUSDB -Q "DBCC SHRINKFILE (N'SUSDB_log' , 0, TRUNCATEONLY)">> "%LOG%"  
echo ------------------------------------------------------------->> "%LOG%"  
echo Ende der Datenbankbereinigung: %DATE% um %TIME% Uhr>> "%LOG%"  
echo =============================================================>> "%LOG%"  
exit

#Region VARIABLES   

# WSUS Connection Parameters: 
[String]$updateServer = $args 
[Boolean]$useSecureConnection = $False 
[Int32]$portNumber = $args[1]   

# Cleanup Parameters: 
# Decline updates that have not been approved for 30 days or more, 
# are not currently needed by any clients, and are superseded by an aproved update. 

[Boolean]$supersededUpdates = $True 
# Decline updates that aren't approved and have been expired my Microsoft.  
[Boolean]$expiredUpdates = $True 
# Delete updates that are expired and have not been approved for 30 days or more. 
[Boolean]$obsoleteUpdates = $True 
# Delete older update revisions that have not been approved for 30 days or more. 
[Boolean]$compressUpdates = $True 
# Delete computers that have not contacted the server in 30 days or more. 
[Boolean]$obsoleteComputers = $True 
# Delete update files that aren't needed by updates or downstream servers.  
[Boolean]$unneededContentFiles = $True   

#EndRegion VARIABLES  

#Region SCRIPT   

# Load .NET assembly 
[void][reflection.assembly]::LoadWithPartialName("Microsoft.UpdateServices.Administration")     

# Connect to WSUS Server 
$Wsus = [Microsoft.UpdateServices.Administration.AdminProxy]::getUpdateServer($updateServer,$useSecureConnection,$portNumber)  

# Perform Cleanup 
$CleanupManager = $Wsus.GetCleanupManager() 
$CleanupScope = New-Object Microsoft.UpdateServices.Administration.CleanupScope($supersededUpdates,$expiredUpdates,$obsoleteUpdates,$compressUpdates,$obsoleteComputers,$unneededContentFiles) 
$CleanupManager.PerformCleanup($CleanupScope)
   
#EndRegion SCRIPT

/******************************************************************************
This sample T-SQL script performs basic maintenance tasks on SUSDB
1. Identifies indexes that are fragmented and defragments them. For certain
   tables, a fill-factor is set in order to improve insert performance.
   Based on MSDN sample at http://msdn2.microsoft.com/en-us/library/ms188917.aspx
   and tailored for SUSDB requirements
2. Updates potentially out-of-date table statistics.
******************************************************************************/

USE SUSDB;
GO
SET NOCOUNT ON;

-- Rebuild or reorganize indexes based on their fragmentation levels
DECLARE @work_to_do TABLE (
    objectid int
    , indexid int
    , pagedensity float
    , fragmentation float
    , numrows int
)

DECLARE @objectid int;
DECLARE @indexid int;
DECLARE @schemaname nvarchar(130); 
DECLARE @objectname nvarchar(130); 
DECLARE @indexname nvarchar(130); 
DECLARE @numrows int
DECLARE @density float;
DECLARE @fragmentation float;
DECLARE @command nvarchar(4000); 
DECLARE @fillfactorset bit
DECLARE @numpages int

-- Select indexes that need to be defragmented based on the following
-- * Page density is low
-- * External fragmentation is high in relation to index size
PRINT 'Estimating fragmentation: Begin. ' + convert(nvarchar, getdate(), 121)   
INSERT @work_to_do
SELECT
    f.object_id
    , index_id
    , avg_page_space_used_in_percent
    , avg_fragmentation_in_percent
    , record_count
FROM 
    sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'SAMPLED') AS f  
WHERE
    (f.avg_page_space_used_in_percent < 85.0 and f.avg_page_space_used_in_percent/100.0 * page_count < page_count - 1)
    or (f.page_count > 50 and f.avg_fragmentation_in_percent > 15.0)
    or (f.page_count > 10 and f.avg_fragmentation_in_percent > 80.0)

PRINT 'Number of indexes to rebuild: ' + cast(@@ROWCOUNT as nvarchar(20))  

PRINT 'Estimating fragmentation: End. ' + convert(nvarchar, getdate(), 121)  

SELECT @numpages = sum(ps.used_page_count)
FROM
    @work_to_do AS fi
    INNER JOIN sys.indexes AS i ON fi.objectid = i.object_id and fi.indexid = i.index_id
    INNER JOIN sys.dm_db_partition_stats AS ps on i.object_id = ps.object_id and i.index_id = ps.index_id

-- Declare the cursor for the list of indexes to be processed.
DECLARE curIndexes CURSOR FOR SELECT * FROM @work_to_do

-- Open the cursor.
OPEN curIndexes

-- Loop through the indexes
WHILE (1=1)
BEGIN
    FETCH NEXT FROM curIndexes
    INTO @objectid, @indexid, @density, @fragmentation, @numrows;
    IF @@FETCH_STATUS < 0 BREAK;

    SELECT 
        @objectname = QUOTENAME(o.name)
        , @schemaname = QUOTENAME(s.name)
    FROM 
        sys.objects AS o
        INNER JOIN sys.schemas as s ON s.schema_id = o.schema_id
    WHERE 
        o.object_id = @objectid;

    SELECT 
        @indexname = QUOTENAME(name)
        , @fillfactorset = CASE fill_factor WHEN 0 THEN 0 ELSE 1 END
    FROM 
        sys.indexes
    WHERE
        object_id = @objectid AND index_id = @indexid;

    IF ((@density BETWEEN 75.0 AND 85.0) AND @fillfactorset = 1) OR (@fragmentation < 30.0)
        SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REORGANIZE';  
    ELSE IF @numrows >= 5000 AND @fillfactorset = 0
        SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD WITH (FILLFACTOR = 90)';  
    ELSE
        SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD';  
    PRINT convert(nvarchar, getdate(), 121) + N' Executing: ' + @command;  
    EXEC (@command);
    PRINT convert(nvarchar, getdate(), 121) + N' Done.';  
END

-- Close and deallocate the cursor.
CLOSE curIndexes;
DEALLOCATE curIndexes;


IF EXISTS (SELECT * FROM @work_to_do)
BEGIN
    PRINT 'Estimated number of pages in fragmented indexes: ' + cast(@numpages as nvarchar(20))  
    SELECT @numpages = @numpages - sum(ps.used_page_count)
    FROM
        @work_to_do AS fi
        INNER JOIN sys.indexes AS i ON fi.objectid = i.object_id and fi.indexid = i.index_id
        INNER JOIN sys.dm_db_partition_stats AS ps on i.object_id = ps.object_id and i.index_id = ps.index_id

    PRINT 'Estimated number of pages freed: ' + cast(@numpages as nvarchar(20))  
END
GO


--Update all statistics
PRINT 'Updating all statistics.' + convert(nvarchar, getdate(), 121)   
EXEC sp_updatestats
PRINT 'Done updating statistics.' + convert(nvarchar, getdate(), 121)   
GO

--Delete sync history
PRINT 'Delete sync history.' + convert(nvarchar, getdate(), 121)  
DELETE FROM tbEventInstance WHERE EventNamespaceID = '2' AND EVENTID IN ('381', '382', '384', '386', '387', '389')  
GO