shrimpfork
asked on
Windows Server Update Services Error - Webpage Dialog
I have received this error when I try to approve any more updates....
Windows Server Update Services encounted an error.
Could not allocate space for object 'tbDeadDeployment' in database 'SUSDB' because the 'PRIMARY' filegroup is full.
There is plenty of room on this server. I do not have the full version of SQL on this server, other than the included version with WSUS. Any ideas?
(I have attached the screen shot of the error.)
WSUSError.jpg
Windows Server Update Services encounted an error.
Could not allocate space for object 'tbDeadDeployment' in database 'SUSDB' because the 'PRIMARY' filegroup is full.
There is plenty of room on this server. I do not have the full version of SQL on this server, other than the included version with WSUS. Any ideas?
(I have attached the screen shot of the error.)
WSUSError.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm not sure where to look for that. Where does the WSUS store the database?
ASKER
When the error occurs, it logs Event ID 386. Here is what the description states....
Synchronization failed. Reason: System.Data.SqlClient.SqlE xception: Could not allocate space for object 'tbXml' in database 'SUSDB' because the 'PRIMARY' filegroup is full.
at Microsoft.UpdateServices.D atabaseAcc ess.DBConn ection.Dra inObsolete Connection s(SqlExcep tion e)
at Microsoft.UpdateServices.D atabaseAcc ess.DBConn ection.Exe cuteComman dNoResult( )
at Microsoft.UpdateServices.I nternal.Da taAccess.E xecuteSPIm portUpdate (Int32 upstreamServerLocalId, String xmlUpdateBlob, Byte[] xmlUpdateBlobCompressed, Int32& localRevisionId)
at Microsoft.UpdateServices.I nternal.Da taAccess.I mportUpdat e(Int32 ussRevLocalId, String xmlUpdateBlob, Byte[] xmlUpdateBlobCompressed, Int32& localRevisionId)
at Microsoft.UpdateServices.I nternal.Da taAccess.I mportUpdat eForCatalo gSync(Stri ng xmlUpdateBlob, Byte[] xmlUpdateBlobCompressed, ServerSyncUrlData[] fileUrls)
at Microsoft.UpdateServices.S erverSync. CatalogSyn cAgentCore .ProcessNe wUpdate(Se rverSyncUp dateData updateData)
at Microsoft.UpdateServices.S erverSync. CatalogS.
Synchronization failed. Reason: System.Data.SqlClient.SqlE
at Microsoft.UpdateServices.D
at Microsoft.UpdateServices.D
at Microsoft.UpdateServices.I
at Microsoft.UpdateServices.I
at Microsoft.UpdateServices.I
at Microsoft.UpdateServices.S
at Microsoft.UpdateServices.S
ASKER
I found what I think is the database location....the file "SUSDB.mdf" is at the 2 GB limit. Now how do I clean this up. My ultimate goal is to install WSUS 3.0.
Somewhere there are some steps to backup your database, reinstall WSUS using some switches to force it to use the english unthrottled WMSDE instance and then restore the database.
How to backup and restore:
http://technet.microsoft.com/en-us/library/cc708546.aspx
Read here for making space by managing WSUS DB from the command line:
http://technet.microsoft.com/en-us/library/cc720466.aspx
How to backup and restore:
http://technet.microsoft.com/en-us/library/cc708546.aspx
Read here for making space by managing WSUS DB from the command line:
http://technet.microsoft.com/en-us/library/cc720466.aspx
Here is some more info:
"The downloadable MSDE only supports a database up to 2GB in size. You need to maintain it to keep it under that limit. Your HOME page in the WSUS administration console should instruct you to run the following command:"
WSUSutil.exe deleteunneededrevisions
So, if you run that command and then you should be able to upgrade from 2.0 to 3.0
"The downloadable MSDE only supports a database up to 2GB in size. You need to maintain it to keep it under that limit. Your HOME page in the WSUS administration console should instruct you to run the following command:"
WSUSutil.exe deleteunneededrevisions
So, if you run that command and then you should be able to upgrade from 2.0 to 3.0
ASKER
I am running the WSUSUTIL.EXE utility to delete unneeded revisions to see if this reduces the size at all.
I am not sure if you can upgrade over the top of 2.0 with a db that has reached the 2gb limit. You might be able to, I just don't know.
Try reducing the size first and then if that doesn't work try updating anyway. I am sure it will moan if it can't manage it. It is Microsoft after all.
Try reducing the size first and then if that doesn't work try updating anyway. I am sure it will moan if it can't manage it. It is Microsoft after all.
ASKER
While running the WSUSutil.exe deleteunneededrevisions, it encountered the same error:
Database cleanup encountered an error, please check your server and try again
Fatal Error: Could not allocate space for object 'tbDeadDeployment' in database
'SUSDB' because the 'PRIMARY' filegroup is full.
The size was not reduced. I would like to fix this before I upgrade to 3.0.
Database cleanup encountered an error, please check your server and try again
Fatal Error: Could not allocate space for object 'tbDeadDeployment' in database
'SUSDB' because the 'PRIMARY' filegroup is full.
The size was not reduced. I would like to fix this before I upgrade to 3.0.
ASKER
I am at a loss here. I'm thinking about removing WSUS 2.0 and installing 3.0. Your thoughts?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have already proceeded on this and have installed 3.0. Thanks for your help.
what are the event ID's you are receiving?