TechShizz | How to Move the WSUS Database

How to Move the WSUS Database


  1. Launch SQL Server Management Studio Express console as an administrator. It is located under Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio Express. 
  2. Fill in the following information and then click Connect
    • Server type: Database Engine
    • Servername: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
    • Authentication: Windows Authentication 
      clip_image004
  3. Expand Databases and right-click on SUSDB and select Tasks > Detach… from the context menu. 
    clip_image006
  4. Select the "Drop Connection" checkbox and click OK. 
    clip_image008
  5. Open explorer and move the C:\WSUS\SUSDB folder to the <new drive>:\WSUS directory.
  6. To reattach the database, right-click on Database and select Attach… from the context menu. 
    clip_image010
  7. On the Attach Databases page select the Add button. 
    clip_image012
  8. Browse to the new location of the SUSDB.mdf database and select OK twice to complete the move. clip_image014

Add comment