RE: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2
It's also worth installing KB2734608 as soon as you've installed WSUS 3.0SP2. Cheers, Phil -Original Message- From: Michael Leone [mailto:oozerd...@gmail.com] Sent: 05 February 2013 20:38 To: NT System Admin Issues Subject: Re: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2 So the boss figures that if we are creating a new database, we might as well install SQL Server 2008 R2 Express, and use that (locally). So we'll go with that, I guess. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin “Any opinion expressed in this e-mail or any attached files are those of the individual and not necessarily those of Hoople Ltd. You should be aware that Hoople Ltd. monitors its email service. This e-mail and any attached files are confidential and intended solely for the use of the addressee. This communication may contain material protected by law from being passed on. If you are not the intended recipient and have received this e-mail in error, you are advised that any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. If you have received this e-mail in error please contact the sender immediately and destroy all copies of it. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin
Re: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2
On Wed, Feb 6, 2013 at 5:01 AM, Randal, Phil phil.ran...@hoopleltd.co.uk wrote: It's also worth installing KB2734608 as soon as you've installed WSUS 3.0SP2. I will keep that in mind. It should show up as soon as I synchronize the first time, it says ... Thanks ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin
RE: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2
I have moved WSUS servers twice. It isn't worth it, just redo it. It doesn't take that long to mass approve the updates. -Original Message- From: Michael Leone [mailto:oozerd...@gmail.com] Sent: Tuesday, February 05, 2013 11:49 AM To: NT System Admin Issues Subject: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2 I've asked this on the WSUS list over at PatchManahement.org, but while I am waiting on their wisdom, I thought I would ask here, as well. I am using WSUS 3.0 SP2 on a Win2003 SP2 VM, and I need to move it to a Win2008 R2 VM, and while I am it, change the server name. Since I posted on the other list, I have determined (I think) that my database is the default Windows Internal database. I have a SUSDB.MDF file, and a separate SUSDB.BAK in a different folder. I must have set that backup up at one point, and pointed it to that backup folder, but it was so long ago, I've forgotten, and there is no documentation here. I found this link - How to move WSUS from one server to another http://blogs.technet.com/b/sus/archive/2009/07/02/how-to-move-wsus-from-one-server-to-another.aspx, This blog post is 3.5 years old; is it still valid? Almost all the comments say this procedure did not work for them. If not, is there a better step-by-step guide? Thanks for any help. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin
RE: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2
+1 just rebuild a new server and change your GPO to point to the new one. John W. Cook Network Operations Manager Partnership For Strong Families 5950 NW 1st Place Gainesville, Fl 32607 Office (352) 244-1610 Cell (352) 215-6944 MCSE, MCP+I, MCTS, CompTIA A+, N+, VSP4, VTSP4 -Original Message- From: Kennedy, Jim [mailto:kennedy...@elyriaschools.org] Sent: Tuesday, February 05, 2013 11:56 AM To: NT System Admin Issues Subject: RE: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2 I have moved WSUS servers twice. It isn't worth it, just redo it. It doesn't take that long to mass approve the updates. -Original Message- From: Michael Leone [mailto:oozerd...@gmail.com] Sent: Tuesday, February 05, 2013 11:49 AM To: NT System Admin Issues Subject: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2 I've asked this on the WSUS list over at PatchManahement.org, but while I am waiting on their wisdom, I thought I would ask here, as well. I am using WSUS 3.0 SP2 on a Win2003 SP2 VM, and I need to move it to a Win2008 R2 VM, and while I am it, change the server name. Since I posted on the other list, I have determined (I think) that my database is the default Windows Internal database. I have a SUSDB.MDF file, and a separate SUSDB.BAK in a different folder. I must have set that backup up at one point, and pointed it to that backup folder, but it was so long ago, I've forgotten, and there is no documentation here. I found this link - How to move WSUS from one server to another http://blogs.technet.com/b/sus/archive/2009/07/02/how-to-move-wsus-from-one-server-to-another.aspx, This blog post is 3.5 years old; is it still valid? Almost all the comments say this procedure did not work for them. If not, is there a better step-by-step guide? Thanks for any help. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin CONFIDENTIALITY STATEMENT: The information transmitted, or contained or attached to or with this Notice is intended only for the person or entity to which it is addressed and may contain Protected Health Information (PHI), confidential and/or privileged material. Any review, transmission, dissemination, or other use of, and taking any action in reliance upon this information by persons or entities other than the intended recipient without the express written consent of the sender are prohibited. This information may be protected by the Health Insurance Portability and Accountability Act of 1996 (HIPAA), and other Federal and Florida laws. Improper or unauthorized use or disclosure of this information could result in civil and/or criminal penalties. Consider the environment. Please don't print this e-mail unless you really need to. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin
Re: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2
Plus one Sent from my BlackBird. -Original Message- From: Kennedy, Jim kennedy...@elyriaschools.org Date: Tue, 5 Feb 2013 16:56:01 To: NT System Admin Issuesntsysadmin@lyris.sunbelt-software.com Reply-To: NT System Admin Issues ntsysadmin@lyris.sunbelt-software.comSubject: RE: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2 I have moved WSUS servers twice. It isn't worth it, just redo it. It doesn't take that long to mass approve the updates. -Original Message- From: Michael Leone [mailto:oozerd...@gmail.com] Sent: Tuesday, February 05, 2013 11:49 AM To: NT System Admin Issues Subject: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2 I've asked this on the WSUS list over at PatchManahement.org, but while I am waiting on their wisdom, I thought I would ask here, as well. I am using WSUS 3.0 SP2 on a Win2003 SP2 VM, and I need to move it to a Win2008 R2 VM, and while I am it, change the server name. Since I posted on the other list, I have determined (I think) that my database is the default Windows Internal database. I have a SUSDB.MDF file, and a separate SUSDB.BAK in a different folder. I must have set that backup up at one point, and pointed it to that backup folder, but it was so long ago, I've forgotten, and there is no documentation here. I found this link - How to move WSUS from one server to another http://blogs.technet.com/b/sus/archive/2009/07/02/how-to-move-wsus-from-one-server-to-another.aspx, This blog post is 3.5 years old; is it still valid? Almost all the comments say this procedure did not work for them. If not, is there a better step-by-step guide? Thanks for any help. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin
Re: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2
On Tue, Feb 5, 2013 at 11:56 AM, Kennedy, Jim kennedy...@elyriaschools.org wrote: I have moved WSUS servers twice. It isn't worth it, just redo it. It doesn't take that long to mass approve the updates. OK ... it's not approving the updates, really. It's rebuilding the groups, and the client history. Once I re-point the GPO to the new server, then the client has to fully scan and report to the new WSUS server which patches it has, and for the server to determine what patches it needs. Those are the parts I would be trying to avoid. How can I migrate that? Do I make the new WSUS server, and somehow replicate from the current to the new, then demote the old, leaving only the new? (in our case - we have a set of servers that are up to date with the latest patches, and another set that one month behind. This lets us test that the patches don't break anything, before rolling them out to the production servers) -Original Message- From: Michael Leone [mailto:oozerd...@gmail.com] Sent: Tuesday, February 05, 2013 11:49 AM To: NT System Admin Issues Subject: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2 I've asked this on the WSUS list over at PatchManahement.org, but while I am waiting on their wisdom, I thought I would ask here, as well. I am using WSUS 3.0 SP2 on a Win2003 SP2 VM, and I need to move it to a Win2008 R2 VM, and while I am it, change the server name. Since I posted on the other list, I have determined (I think) that my database is the default Windows Internal database. I have a SUSDB.MDF file, and a separate SUSDB.BAK in a different folder. I must have set that backup up at one point, and pointed it to that backup folder, but it was so long ago, I've forgotten, and there is no documentation here. I found this link - How to move WSUS from one server to another http://blogs.technet.com/b/sus/archive/2009/07/02/how-to-move-wsus-from-one-server-to-another.aspx, This blog post is 3.5 years old; is it still valid? Almost all the comments say this procedure did not work for them. If not, is there a better step-by-step guide? Thanks for any help. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin
RE: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2
The actual moving of the database to another server is not difficult as long as you don't change from internal to SQL database. The problem is in renaming the server. When you do that you have to remember to change any GPO's that are associated with WSUS. The database export and import procedures are still the same that I'm aware of, use the WSUSutil command line. The OS should not make any difference at all. Thomas would have more current knowledge of moving WSUS than I do. If the environment is not very large you could just install a fresh copy of WSUS on the new server, re-point the GPO's and let the clients populate the new database on their own. Then import only the metadata of approved updates. That way you're not getting old machines that may not be on the network any longer and you start with a much cleaner database. William (Bill) Whitney The Principia -Original Message- From: Michael Leone [mailto:oozerd...@gmail.com] Sent: Tuesday, February 05, 2013 10:49 AM To: NT System Admin Issues Subject: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2 I've asked this on the WSUS list over at PatchManahement.org, but while I am waiting on their wisdom, I thought I would ask here, as well. I am using WSUS 3.0 SP2 on a Win2003 SP2 VM, and I need to move it to a Win2008 R2 VM, and while I am it, change the server name. Since I posted on the other list, I have determined (I think) that my database is the default Windows Internal database. I have a SUSDB.MDF file, and a separate SUSDB.BAK in a different folder. I must have set that backup up at one point, and pointed it to that backup folder, but it was so long ago, I've forgotten, and there is no documentation here. I found this link - How to move WSUS from one server to another http://blogs.technet.com/b/sus/archive/2009/07/02/how-to-move-wsus-from-one-server-to-another.aspx, This blog post is 3.5 years old; is it still valid? Almost all the comments say this procedure did not work for them. If not, is there a better step-by-step guide? Thanks for any help. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin
Re: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2
Agreed. It only takes a couple days for the database to update. Roger Wright ___ Congressional Mantra: Spending will continue increase until deficits improve. On Tue, Feb 5, 2013 at 11:56 AM, Kennedy, Jim kennedy...@elyriaschools.orgwrote: I have moved WSUS servers twice. It isn't worth it, just redo it. It doesn't take that long to mass approve the updates. -Original Message- From: Michael Leone [mailto:oozerd...@gmail.com] Sent: Tuesday, February 05, 2013 11:49 AM To: NT System Admin Issues Subject: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2 I've asked this on the WSUS list over at PatchManahement.org, but while I am waiting on their wisdom, I thought I would ask here, as well. I am using WSUS 3.0 SP2 on a Win2003 SP2 VM, and I need to move it to a Win2008 R2 VM, and while I am it, change the server name. Since I posted on the other list, I have determined (I think) that my database is the default Windows Internal database. I have a SUSDB.MDF file, and a separate SUSDB.BAK in a different folder. I must have set that backup up at one point, and pointed it to that backup folder, but it was so long ago, I've forgotten, and there is no documentation here. I found this link - How to move WSUS from one server to another http://blogs.technet.com/b/sus/archive/2009/07/02/how-to-move-wsus-from-one-server-to-another.aspx , This blog post is 3.5 years old; is it still valid? Almost all the comments say this procedure did not work for them. If not, is there a better step-by-step guide? Thanks for any help. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin
Re: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2
On Tue, Feb 5, 2013 at 2:54 PM, Robert Peterson robert.peter...@prin.edu wrote: The actual moving of the database to another server is not difficult as long as you don't change from internal to SQL database. The problem is in renaming the server. When you do that you have to remember to change any GPO's that are associated with WSUS. The database export and import procedures are still the same that I'm aware of, use the WSUSutil command line. That's not working for me. wsusutil export Old-Server-CAB.CAB Old-Server-LOG.LOG give me a binary file as the LOG, and an empty zero-byte CAB file. If the environment is not very large About 130 servers ... you could just install a fresh copy of WSUS on the new server, re-point the GPO's and let the clients populate the new database on their own. Then import only the metadata of approved updates. That way you're not getting old machines that may not be on the network any longer and you start with a much cleaner database. That's what I am hoping to do. I have installed WSUS on the new server, and am about to synchronize updates. Then I was going to change the GPO and let it re-populate the DB. But I have nothing to import metadata from ... I can approve everything up till last Patch Tuesday date, of course. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin
Re: Advice on migrating WSUS 3.0 SP2 from Win2003 32bit to Win2008 R2
So the boss figures that if we are creating a new database, we might as well install SQL Server 2008 R2 Express, and use that (locally). So we'll go with that, I guess. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/ ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to listmana...@lyris.sunbeltsoftware.com with the body: unsubscribe ntsysadmin