How to Move the WSUS Database to a Different SQL Server

May 3rd, 2014 by Rossy Guide

Tutorial:

1. Install SQL Server 2005.

2. Stop the IIS Admin service and the Update Services service.

o Click Start-> Programs-> Administrative Tools->click Services.
o Right-click IIS Admin Service, and then click Stop.
o Right-click Update Services, and then click Stop.

3. Detach the WSUS database from the original SQL server.

o Right-clicking the SUSDB, choosing Task and then choose detach.
o Choose OK in the “Detach Database” wizard Page.
o Choose the “Drop Connections” box.

4. Copy the database files from the old SQL server to the new SQL server. Most of the time these files will be in the MSSQL\Data directory.

5. Attach the database files as SUSDB to the new SQL server.

o Right-click Databases and choose Attach.
o Point to the place where you copied the files
o Choose “OK”.

6. Back on the WSUS server, open the registry editor.

o Click Start-> Run-> Type regedit->click OK.

7. Browse to HKLM \ SOFTWARE \ Microsoft \ UpdateServices \ Server \ Setup \ SqlServerName.

o In the Value box , type [ServerName]\[InstanceName]
o Click OK.

8. Open Services and start the IIS Admin service and Update Services service.

o Click Start-> Programs-> Administrative Tools->click Services.

9. Restart the services IIS Admin, HTTP SSL, WWW Publishing, and the Updates Services.

10. To verify that everything is working run the Update Services Console and give it a moment to connect.

Leave a Reply