Migrate WSUS to another Server/Database

Hi experts,

I`m planning to migrate my WSUS Server from a Windows Server 2008 R2 (DB is on a full SQL Server 2008) to a Windows Server 2012 R2 with WID.

What I would do:

1. Install WSUS role an Win2k12 R2 with WID
2. Configure WSUS to be replica Server of the old one
3. Let the Server replicate
4. Change GPO for WSUS pointing to the new Server

What do you think about that? I`m worrying about SQL -> WID. Do you see a Problem here?

Thanks in advance!
Who is Participating?

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

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.

Cliff GaliherCommented:
Won't work. WSUS does not have a replica architecture as you attempted to describe. It's downstream functionality is quite different. Stick to official guidance instead.


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
SystemadministrationAuthor Commented:
OK, on the machine I already have a MS SQL Server 2014 Express.
Could I use that database for migration?

My current DB is 4,7 GB.
I know the limit for Express is 10 GB. What do you think? Is it enough? What could you do, if it will reach 10GBs?

I`m thinking about installing a brand new WSUS and let that new WSUS synch fresh updates. After that I would change the GPO and clients will report to the new server.

What do you think about that?
Cliff GaliherCommented:
I thought you were going to use the internal db. If you haven't made those basic decisions yet, you should read the planning section of the migration link I already posted.

As for going fresh and syncing... in general I think that just creates more work and is less efficient.
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

SystemadministrationAuthor Commented:
I see people on the web who have migrated 2008->2012 by setting up a fresh WSUS server in replica mode on Win2k12 R2.

https://thwack.solarwinds.com/thread/64229  (2nd post)

Why can`t I do this in my environment? Does this have something to do that we are currently running a SQL server Database and want to go to the WID?
Cliff GaliherCommented:
No. It is just a bad thing to do. There is plenty of bad advice on the internet. And out of ignorance or embarrassment, people who break their environments rarely come back and post their mistakes in the same threads where they earlier espoused their successes. If you like following random advice from the internet over official easy-to-follow guidance from Microsoft, by all means. Its your server to break. I am confused by the resistance to just dong it the right way though.
Nagendra Pratap SinghDesktop Applications SpecialistCommented:
There is plenty of bad advice on the internet.

And WID is very very limited compared to SQL express.
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.