Solved

TSQL Timeout Expired

Posted on 2013-01-22
7
943 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
Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

 
LVL 23

Accepted Solution

by:
Ayman Bakr earned 500 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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…

691 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