TSQL Timeout Expired

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.

Cleanup Results:

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?
DB-maint.sql
LVL 23
Thomas GrassiSystems AdministratorAsked:
Who is Participating?
 
Ayman BakrConnect With a Mentor Senior ConsultantCommented:
I have found another solution in a thread which more resembles your design, SQL with WSUS - check it out:

http://www.mombu.com/microsoft/windows-server-update-services/t-replica-servers-stopped-synchronizing-560790.html

Hope this helps!
0
 
Ayman BakrSenior ConsultantCommented:
0
 
Thomas GrassiSystems AdministratorAuthor Commented:
Just reviewed the article

My question is where is this timeout value kept?

How can I view it and the change it?
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
Ayman BakrSenior ConsultantCommented:
I assume you have .Net framework installed and according to the thread you should search for the file XYZModel.Designer.vb, where XYZ should stand for your entity. Well, I am not sure whether the existence of this file depends on having EF or not.

Can you search for that file?
0
 
Thomas GrassiSystems AdministratorAuthor Commented:
Ok will check this out later tonight
0
 
Thomas GrassiSystems AdministratorAuthor Commented:
I searched for XYZModel.Designer.vb, not found.

The www.mombu.com article is talking about replica servers not my case here.

My sql WSUS database is working ok

Just this maint script I have is not connecting to SQL

SQL and WSUS are on the same Windows 2008 server.
The registry entries for WSUS are pointing to the SQL server correctly.

this command c:\util\wsus_cleanup_cl server010 f 80 all

When you select all at the end it does all WSUS maintenance includig accessing the sql database.
0
 
Thomas GrassiSystems AdministratorAuthor Commented:
I figured this out myself

I just changed c:\util\wsus_cleanup_cl server010 f 80 all

to c:\util\wsus_cleanup_cl server010 f 80 superseded expired obsolete compress computers files

This way it will not do the SQL process.

I use SQL maint plans to clean up the sql wsus database which works fine.

Thanks for helping
0
All Courses

From novice to tech pro — start learning today.