Any easy way to approve updates exactly equal to the old Server / WSUS

Hi

We have a customer with an WSUS Server 2008 (not R2) that is crashing and cannot be migrated. The Server has also lot of file corruptions. There is also no backup from the Server.
The customer has about 62 Departments. Each department has self developed Software. All Security updates have been approved to all. But other updates that made problems are not approved to most of departments. If we will approve all updates one by one exactly equal to the old Server we will need many weeks. Is there any easy way to do this? I don’t think there is a way that we can export a file and import all approved updates to the new 2012 R2 Server?

Many thanks in advance
LVL 19
*** Hopeleonie ***IT ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

gruppomgCommented:
The information is on SQL or Windows Internal DataBase. If you can copy/export the DB will be possible to use the same rules.

http://www.tekronin.net/2014/02/07/migrating-wsus-3-2-to-windows-server-2012-r2/

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
*** Hopeleonie ***IT ManagerAuthor Commented:
Hi gruppomg

We think the Windows Internal DataBase maybe also corrupted. So we are afraid.
Is the Windows Internal DataBase same on 2008 and 2012 R2?
gruppomgCommented:
On WSUS 6 (Windows 2012) is compatible with Windows Internal Database (WID)
https://technet.microsoft.com/en-us/library/hh852344.aspx

Use SQL Express and SQL Studio Managment will provide you more tools to recover the DataBase.
https://technet.microsoft.com/pt-br/library/dd939918(v=ws.10).aspx

Try to copy the WID files and attach to other SQL instance in order to check the DB healt
*** Hopeleonie ***IT ManagerAuthor Commented:
I will try it
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
Windows Server 2012

From novice to tech pro — start learning today.