Microsoft 70-411 Exam – Q50

Your network contains an Active Directory domain named contoso.com. The domain contains two member servers named Server1 and Server2. All servers run Windows Server 2012 R2. Server1 has the Windows Server Update Services (WSUS) server role installed. WSUS is configured to use a Windows Internal Database. Server2 has Microsoft SQL Server 2008 R2 Standard deployed.

You detach the SUSDB database from Server1 and attach the database to Server2.
You need to ensure that Windows Deployment Services (WDS) on Server1 uses the database hosted on Server2.
What should you do on Server1?

A. Configure an ODBC file data source
B. Run the wsusutil command
C. Edit the registry
D. Configure an ODBC system data source

Correct Answer: C

Explanation:

Migrating the WSUS database if it is running on the WSUS server
1. Install SQL Server by using the Server and Client Tools option on your WSUS server.
2. Click Start, point to Programs, point to Administrative Tools, and then click Services.
3. Right-click IIS Admin Service, and then click Stop.
4. Right-click Update Services, and then click Stop.
5. Run the following SQL command to detach the WSUS database (SUSDB) from the Windows Internal Database instance by using the sqlcmd utility.
6. In SQL Server Management Studio, under the Instance node, right-click Databases, select Properties, and then click Attach.
7. In this step, you will verify that NT AUTHORITY\NETWORK SERVICE has login permissions to the instance of SQL Server and to the WSUS database. If it does not, you will have to add it to both locations. This account should also be a member of the webService role on the WSUS database.
8. In the Attach Databases box, under Databases to attach, locate the susdb.mdf file, and then click OK.
9. In this step, you will edit the registry to point WSUS to the instance of SQL Server that now holds the WSUS database and to recognize the new database for future WSUS updates. If you have not already done so, export the keys in the registry that you plan to edit or back up the whole registry.

a. Click Start, click Run, type regedit, and then click OK.

b. Locate the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\UpdateServices\Server\Setup\SqlServerName
In the Value text box, type [ServerName]\[InstanceName], and then click OK. If the instance name is the default instance, type
[ServerName].

c. Find the following key:
HKEY_LOCAL_MACHINE\Software\Microsoft\Update Services\Server\Setup\wYukonInstalled
In the Value text box, type 0, and then click OK.

10. Click Start, point to Programs, point to Administrative Tools, and then click Services.
11. Right-click IIS Admin Service, and then click Start.
12. Right-click Update Services, and then click Start.
13. Verify that the database migration was successful by opening the WSUS administrative console.