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
Solved

Migrate WSUS internal db to SQL 2008

Posted on 2012-03-26
2
470 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard 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.
A procedure for exporting installed hotfix details of remote computers using powershell
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

839 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