Dark Developments Where Knowledge Meets Power

6Mar/120

WSUS – Move WSUS Database Files to a Different Volume

WSUS - Move WSUS Database Files to a Different Volume

  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.
  4. clip_image006

  5. Select the "Drop Connection" checkbox and click OK. It is possible that you receive an error message that the database can't be detached. This is because the services IIS Admin Server and Update Services are still running. Make sure that the services are stopped and try to detach the SQL database again.
  6. clip_image008

  7. Open explorer and move the C:\WSUS\SUSDB folder to the <new drive>:\WSUS directory.
  8. To reattach the database, right-click on Database and select Attach… from the context menu.
  9. clip_image010

  10. On the Attach Databases page select the Addbutton.
  11. clip_image012

  12. Browse to the new location of the SUSDB.mdf database and select OK twice to complete the move.

www.geeklab.info/2010/05/how-to-move-your-susdb-wsus/

blogs.technet.com/b/sbs/archive/2009/09/23/how-to-move-wsus-content-and-database-files-to-a-different-partition.aspx

Print Friendly
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

No trackbacks yet.