• Run a SQL script to identify how update storage is being managed on the front-end computer
To identify on the back-end computer how update storage is being managed on the front-end computer • At the command prompt, type one of the following commands, depending on how you set up the front-end computer: • If you chose local storage on the front-end computer, type: "%programfiles%\update services\tools\osql\osql.exe" -S SQLServerName -E -b -n -Q "USE SUSDB UPDATE dbo.tbConfigurationA SET HostOnMu = '0' UPDATE dbo.tbConfigurationB SET LocalContentCacheLocation = N'LocalContentCacheLocation Value'" whereSQLServerName is the name of the SQL Server instance that holds the SUSDB database; where %programfiles% is the location of the Program Files folder on the front-end computer; and where LocalContentCacheLocation Value is the actual string used to identify where in the file system of the front-end computer to store content, with \WSUSContent appended to the end. For example, if you used C:\WSUS on the front-end computer, you would type C:\WSUS\WSUSContent. Do not use a network location or a UNC path. Do not add a trailing backslash (\). • If you chose remote storage on Microsoft Update, type the following: "%programfiles%\update services\tools\osql\osql.exe" -S SQLServerName -E -b -n -Q "USE SUSDB UPDATE dbo.tbConfigurationA SET HostOnMu = '1' UPDATE dbo.tbConfigurationB SET LocalContentCacheLocation = N'%programfiles%\Update Services\WsusContent'" where SQLServerName is the name of the SQL Server instance on the back-end computer; and where %programfiles% is the location of the Program Files folder on the front-end computer.