Hail to all Professionals,
I have a wsus 3.0 SP2 installed on windows server 2003 using WID which I'm planning to get rid off by doing a fresh installation on a windows server 2012 R2 using a remote SQL 2012.
I have over 100 GB of meta data files on the 2003 server with a 32000 updates (of which 25000 are declined).
Also I have a 2008 server which acts as a replica of the 2003 server.
Here' how I' m planning to conduct the upgrade:
1. Install the wsus role on the 2012 server
2. Copy the meta data files to new server
3. Since I have over 1000 clients, I'm planning to have the new server use the same identity
In order to make it work I have to use the same IP and DNS name for windows update on the 2012 server and shutdown the 2003 server.
this way clients will still be able to communicate with the new server without updating the group policy.
I found info about this but I don't know how it is brought to bear ?
4. Get rid of the declined updates
The reason why I'm not doing a backup/restore of the old database, is that I have over 25000 declined updates still showing on the update view (Drivers & Languages data), I have tried several clean up with no success. so the new SQL 2012 database will start anew.
For that I'm thinking to set the 2012 server as a replica of the 2003 just until the updates/computer groups are synchronized than bring it to Upstream and shutdown the old one. What is the best approach here: re-download the updates or is there a way to delete the declined updates from the database using powershell cmdlets ?
5. Restore replica with 2008 server
Thank you for submitting your valuable expertise/knowledge and in the act take part in this successful journey.