?
Solved

TSQL Timeout Expired

Posted on 2013-01-22
7
Medium Priority
?
944 Views
Last Modified: 2013-02-22
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
0
Comment
Question by:Thomas Grassi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 23

Expert Comment

by:Ayman Bakr
ID: 38808419
0
 
LVL 23

Author Comment

by:Thomas Grassi
ID: 38810590
Just reviewed the article

My question is where is this timeout value kept?

How can I view it and the change it?
0
 
LVL 23

Expert Comment

by:Ayman Bakr
ID: 38811172
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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 23

Accepted Solution

by:
Ayman Bakr earned 1500 total points
ID: 38811207
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
 
LVL 23

Author Comment

by:Thomas Grassi
ID: 38811234
Ok will check this out later tonight
0
 
LVL 23

Author Comment

by:Thomas Grassi
ID: 38814256
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
 
LVL 23

Author Closing Comment

by:Thomas Grassi
ID: 38920252
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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question