Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

TSQL Timeout Expired

Posted on 2013-01-22
7
Medium Priority
?
949 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

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.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

604 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