Solved

WSUS 2.0 database Database 'SUSDB' exceeds size limit.

Posted on 2009-05-15
12
6,958 Views
Last Modified: 2012-05-07
Hi,

I have a SBS 2003 SP2 and my SUSDB got somehow damaged?  At least its current file size of SUSDB.mdf is > 6 GB and I can't do anything with it.
I'd like to shrink it with OSQL but everything fails with
Database 'SUSDB' exceeds size limit.

Of course WSUS is no longer working now.

Right now upgrading to WSUS 3.0 or reinstalling WSUS 2.0 would be an option I'd prefer to pospone a few weeks.
Shouldn't it be possible to compact/shrink the database back to a normal level somehow?





0
Comment
Question by:Michael Pfister
[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
  • 7
  • 5
12 Comments
 
LVL 13

Expert Comment

by:St3veMax
ID: 24393208
First of all; Take a backup of the database.

In SLQ Management Studio; Right click on the DB; Look @ the Files tab and then look at the max size. You may need to adjust that OR check you have not run out of disk space on the server.

HTH
0
 
LVL 28

Author Comment

by:Michael Pfister
ID: 24422946
I do not have SQL Management Studio installed...
0
 
LVL 28

Author Comment

by:Michael Pfister
ID: 24422955
.. and I can't take a backup ... same error message.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 13

Expert Comment

by:St3veMax
ID: 24422984
OK; You cant do anything really without SQL Management Studio.

Is there another disk on the server that you can put the backup file?
0
 
LVL 28

Author Comment

by:Michael Pfister
ID: 24423119
The disk has more than 70 GB free...
0
 
LVL 13

Expert Comment

by:St3veMax
ID: 24423152
You really need to install SQL Server Management Studio Somewhere and connect into the database. That way you can look at what's inside the database and determine if it's whitespare or actually data by running one of the built-in reports;

Right click on teh Database Name under 'Databases', Select 'Reports', 'Standard Reports', 'Disk Usage by Table'

HTH
0
 
LVL 28

Author Comment

by:Michael Pfister
ID: 24423234
Ok, will go on site next Friday and try to get the SQL Management Studio.
0
 
LVL 13

Assisted Solution

by:St3veMax
St3veMax earned 500 total points
ID: 24423251
Can you see the server remotely? If so; You can download SQL Server Management Studio Express which should allow you to do what you need to.

HTH
0
 
LVL 28

Author Comment

by:Michael Pfister
ID: 24423292
Last time remote session was a pain.. but I'll try...
0
 
LVL 13

Expert Comment

by:St3veMax
ID: 24423304
Hold on...By remote session I'm assuming you're reffering to RDP / mstsc?

If so; Install SQL Management Studio locally on your machine and try to connect to the server from your machine; May make it a little easier for you.
0
 
LVL 28

Author Comment

by:Michael Pfister
ID: 24449273
No RDP.
SQL Server Management Studio is also unable to connect to the database.
I'm trying to restore a backup thats about a month old.
0
 
LVL 28

Accepted Solution

by:
Michael Pfister earned 0 total points
ID: 24462150
Ok, the restore was successful. WSUS is up and running again. Still the SUSDB file is > 6 GB.

I tried to cut down the WSUS database by running

wsusutil deleteuneededrevisions

but the utility times out after 3 hours everytime I run it. I've found several articles describing the same problem but all say, run it several times and it will work. So I continue trying....

Finally I probably have to upgrade to WSUS 3.0...

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/SBS_Small_Business_Server/Q_23612554.html
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

739 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