WSUS migration to Win 2012 unsuccessful.

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?
thanks.
WSUS.JPG
DB.JPG
LVL 1
usmansultanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AntzsInfrastructure ServicesCommented:
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.
usmansultanAuthor Commented:
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 ?
Radhakrishnan RSenior Technical LeadCommented:
Hi,

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 AdministratorCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.