Windows 2008 R2 Standard 64bit
SQL Server 2008 64 bit
WSUS 3.1 Sp3
WSUS Database is on the SQL Server
Monthly I run this
c:\util\wsus_cleanup_cl server010 f 80 all
I get this report
1/15/2013 2:00:00 PM
Running server cleanup now. A cleanup report will be added once cleanup is done.
5101361126byte(s) removed from the WSUS Content directory.
0 expired update(s) were declined in WSUS.
0 computer(s) were removed from WSUS.
587 obsolete update(s) were removed from WSUS.
0 superseded update(s) were declined in WSUS.
10741 Unneeded revision(s) were removed from WSUS.
Running the SQL maintenance script now...
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The job runs ok but the SQL part fails
The "ALL" option will run all of the cleanup job parameters which includes the SQL database maint routine
I attached the SQL TSQL code that comes with WSUS server.
I do not see anywhere how this points to the correct server .
Can someone help me out here?