WSUS migration to Win 2012 unsuccessful.

usmansultan used Ask the Experts™
WE have moved WSUS from 2008 to 2012 R2 server, I gave same name and IP address to new server, have installed the roles of WSUS and IIS, migrated the DB, for which it keeps showing its restoring (Screenshot attached) because DB size is 15 GB and free version of WSUS is 10 GB.
On the console of WSUS it doesn't show any updates (Screenshot attached).
So moving forward, should I install a full version of SQL Standard?
anything else I have to do to start see computers under WSUS Console?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AntzsInfrastructure Services

Do you still need the historical data from the previous WSUS?  If you dont, it may be simpler to just install a new WSUS and redownload the updates from Microsoft again.  

The reason why you are not seeing any computer objects is probably due to the DB which is not in the running state.


Sorry install new wsus? Its a new server.
Dont need hostorical data if its not relevant.
I just want to make it work asap. So best way would be to install new sql server and import DB ?
systechSenior Technical Lead


It's better to use the default database for WSUS which is 'Windows Internal Database (WID). This is dedicated for WSUS and there is 254GB size limit which you never hit that limit.

Remove the role including database
Delete the content store (if it's not required)
Install WSUS with Windows Internal Database
Configure the necessary products
Set appropriate GPO's to communicate with clients

Good luck
Seth SimmonsSr. Systems Administrator

Dont need hostorical data if its not relevant.

then why migrate the database?

anything else I have to do to start see computers under WSUS Console?

do you have computer groups configured in your GPO?  doesn't show in the screenshot so you won't see computers that can't add themselves to a group that doesn't exist.  create the computer groups again with the same name and clients should start appearing on the next scheduled check

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial