Answered by:
Remote SQL Database for SUSdb

Question
-
I currently have 4 sus server in seperate domain that are havign a issues.
I keep gettng connection reset on the GUI of WSUS.
I noticed that my DB on the remote SQL server range from 20 GB to 40 GB
The quesiton I have are this.
Is there a max size for the SUSDB on a remote db ?
if so what is it the size of it.
what command do I need to issue to shrink remove the database
I tired to use the server option in the WSUS GUI but keep getting server node rest. I even tried to install the Admin console on a different box and still get the node reset.
if there is no max size to the database any idea what is causing the connection to be reset upon loading?
The event viewer here are the issues
Event code: 3001
Event message: The request has been aborted.
Event time: 3/27/2015 10:04:48 AM
Event time (UTC): 3/27/2015 2:04:48 PM
Event ID: 277f7d5e05e74d02adc63113bfe972a2
Event sequence: 181
Event occurrence: 60
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT/ServerSyncWebService-5-130718885197848750
Trust level: Full
Application Virtual Path: /ServerSyncWebService
Application Path: C:\Program Files\Update Services\WebServices\ServerSyncWebService\
Machine name: SCCWASWSUS
Process information:
Process ID: 3980
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: HttpException
Exception message: Request timed out.
Request information:
Request URL: http://sccwaswsus/ServerSyncWebService/serversyncwebservice.asmx
Request path: /ServerSyncWebService/serversyncwebservice.asmx
User host address: 10.210.200.95
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 350
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace:
Custom event details:
and this one
The WSUS administration console has encountered an unexpected error. This may be a transient error; try restarting the administration console. If this error persists,
Try removing the persisted preferences for the console by deleting the wsus file under %appdata%\Microsoft\MMC\.
System.NullReferenceException -- Object reference not set to an instance of an object.
Source
Microsoft.UpdateServices.UI.SnapIn
Stack Trace:
at Microsoft.UpdateServices.UI.SnapIn.Pages.ServerSummaryPage.backgroundWorker_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
I am delete the MMC WSUS shortcut and still getting this.
Thanks
Mike
Mike
Friday, March 27, 2015 2:52 PM
Answers
-
Regardless if local DB or remote DB, WSUS requires routine maintenance of the DB.
The simplest method is to use the built-in Server Cleanup Wizard, but, this may timeout and fail if the DB is already in a poor state of health.
https://technet.microsoft.com/en-us/library/dd939856(v=ws.10).aspx
Some other related recommended reading:
http://community.spiceworks.com/how_to/103094-automate-wsus-cleanup
http://wsus.codeplex.com/releases/view/17612
http://definitebounds.blogspot.com.au/2013/05/maintain-your-wsus-server-properly.html
https://gallery.technet.microsoft.com/scriptcenter/6f8cde49-5c52-4abd-9820-f1d270ddea61#content
http://blog.coretech.dk/kea/house-of-cardsthe-configmgr-software-update-point-and-wsus/
Don
(Please take a moment to "Vote as Helpful" and/or "Mark as Answer", where applicable.
This helps the community, keeps the forums tidy, and recognises useful contributions. Thanks!)- Marked as answer by maserowik Wednesday, April 1, 2015 4:13 PM
Saturday, March 28, 2015 9:36 AM
All replies
-
Regardless if local DB or remote DB, WSUS requires routine maintenance of the DB.
The simplest method is to use the built-in Server Cleanup Wizard, but, this may timeout and fail if the DB is already in a poor state of health.
https://technet.microsoft.com/en-us/library/dd939856(v=ws.10).aspx
Some other related recommended reading:
http://community.spiceworks.com/how_to/103094-automate-wsus-cleanup
http://wsus.codeplex.com/releases/view/17612
http://definitebounds.blogspot.com.au/2013/05/maintain-your-wsus-server-properly.html
https://gallery.technet.microsoft.com/scriptcenter/6f8cde49-5c52-4abd-9820-f1d270ddea61#content
http://blog.coretech.dk/kea/house-of-cardsthe-configmgr-software-update-point-and-wsus/
Don
(Please take a moment to "Vote as Helpful" and/or "Mark as Answer", where applicable.
This helps the community, keeps the forums tidy, and recognises useful contributions. Thanks!)- Marked as answer by maserowik Wednesday, April 1, 2015 4:13 PM
Saturday, March 28, 2015 9:36 AM -
Thanks
I can say that there has never been any database maintenance done since I started there.
I was able to get 3 out of the 5 cleanup working with the build in server clean up wizard.
I will be working with my SQL team to run the script and maybe get the wsus server back on line soon.
Thanks
Mike
Mike
Saturday, March 28, 2015 7:11 PM