An Engineers Notebook

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: \.pipeMSSQL$MICROSOFT##SSEEsqlquery
    • Authentication: Windows Authentication 
  3. Expand Databases and right-click on SUSDB and select Tasks > DetachÂ… from the context menu. 
  4. Select the “Drop Connection” checkbox and click OK. 
  5. Open explorer and move the C:WSUSSUSDB folder to the <new drive>:WSUS directory.
  6. To reattach the database, right-click on Database and select AttachÂ… from the context menu. 
  7. On the Attach Databases page select the Add button. 
  8. Browse to the new location of the SUSDB.mdf database and select OK twice to complete the move. clip_image014

Leave a Reply

Your email address will not be published.