WSUS database and content migration

No Gravatar

This is the simplistic process of moving the db and files for WSUS to a new drive or folder.

Move content

Using the command prompt, run the following

Move the database

Running Microsoft SQL Server Management Studio Express

  • connect to the the Database Engine using \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query as the server and use Windows Authentication
  • select the SUSDB database and detach it dropping any connections
  • move the SUSDB.mdf and SUSDB.ldf files to a new location using Windows Explorer
  • using SSMSE, attache the database (right-click on Databases, select attach)

*If you have trouble connecting to SQL, see this forum chain:





October 15, 2012

Posted In: WSUS