?
Solved

Migrate WSUS internal db to SQL 2008

Posted on 2012-03-26
2
Medium Priority
?
474 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 2000 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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

777 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