Solved

Migrate WSUS internal db to SQL 2008

Posted on 2012-03-26
2
468 Views
Last Modified: 2012-03-26
We want to move our WSUS internal db from its current Windows 2008 server to our SQL server, which is Server 2008 R2 with SQL 2008. I have found a number of migration scenarios here but not this one. The WSUS install will stay where it is.

BTW, I could not find WSUS anywhere in the list of EE topics...
0
Comment
Question by:LarryDAH
2 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 37768210
This Technet article seems to walk through the process you're asking about:

http://technet.microsoft.com/en-us/library/cc708558(v=ws.10).aspx

Essentially, you detach the database from the Internal DB (which is a modified version of SQL Express), attach it to your SQL Server, and then make some registry changes on your WSUS server to tell it where to find the database (updating the connection string).

There are hundreds of articles out there about physically moving the data files, but keeping the Windows Internal DB, which isn't what you're looking for, so this one was a bit tough to find.
0
 

Author Comment

by:LarryDAH
ID: 37768363
That looks like what I need. I refers to SQL 2005 but I do not think that that will matter though. Thanks.
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question