• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7075
  • Last Modified:

WSUS 2.0 database Database 'SUSDB' exceeds size limit.

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
Michael Pfister
Asked:
Michael Pfister
  • 7
  • 5
2 Solutions
 
St3veMaxCommented:
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
 
Michael PfisterAuthor Commented:
I do not have SQL Management Studio installed...
0
 
Michael PfisterAuthor Commented:
.. and I can't take a backup ... same error message.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
St3veMaxCommented:
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
 
Michael PfisterAuthor Commented:
The disk has more than 70 GB free...
0
 
St3veMaxCommented:
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
 
Michael PfisterAuthor Commented:
Ok, will go on site next Friday and try to get the SQL Management Studio.
0
 
St3veMaxCommented:
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
 
Michael PfisterAuthor Commented:
Last time remote session was a pain.. but I'll try...
0
 
St3veMaxCommented:
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
 
Michael PfisterAuthor Commented:
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
 
Michael PfisterAuthor Commented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now