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

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.
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.