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: http://channel9.msdn.com/Forums/TechOff/255490-How-to-connect-MICROSOFTSSEE

References:

  • http://blogs.technet.com/b/sus/archive/2008/05/19/wsus-how-to-change-the-location-where-wsus-stores-updates-locally.aspx
  • http://blogs.technet.com/b/sbs/archive/2009/09/23/how-to-move-wsus-content-and-database-files-to-a-different-partition.aspx

 

 

October 15, 2012

Posted In: WSUS