Moving WSUS 3.0 SQL Database tgoddard <tgoddard[ at ]encomaterials.com> 5/29/2007 1:42:37 PM I need to relocate my WSUS 3.0 database from Windows Internal Database (WSEE) to a SQL 2005 Std. database on a different server. How best to do this?

Re: Moving WSUS 3.0 SQL Database "Lawrence Garvin \(MVP\)" <onsitech[ at ]community.nospam> 5/29/2007 10:57:17 PM "tgoddard" <tgoddard[ at ]encomaterials.com> wrote in message news:1180446157.058530.103170[ at ]w5g2000hsg.googlegroups.com... [Quoted Text] >I need to relocate my WSUS 3.0 database from Windows Internal Database > (WSEE) to a SQL 2005 Std. database on a different server. How best to > do this? [1] Detach SUSDB from WID [2] Install WSUSv3 on SQL Server 2005. [3] Replace/reattach SUSDB in new SQL Server 2005 server. [4] Edit registry value "SqlServerName" on front-end server at HKLM\Software\Microsoft\Update Services\Server\Setup to point to the new back-end server. -- Lawrence Garvin, M.S., MCTS, MCP Independent WSUS Evangelist MVP-Software Distribution (2005-2007) https://mvp.support.microsoft.com/profile=30E00990-8F1D-4774-BD62-D095EB07B36E Everything you need for WSUS is at http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx And, almost everything else is at http://wsusinfo.onsitechsolutions.com .....