Folgende Fehlermeldung habe ich erhalten "ApplicationException: Failed to approve some updates "
Basically, there is bug that can exist with some replica servers, regardless of
using MSDE or SQL.
So here is the fix:
1) Create a text file named addDeploymentIndex.sql
2) Add the following text to the sql file:
USE SUSDB
GO
BEGIN TRAN
IF NOT EXISTS (SELECT * FROM sysindexes where name='nc7DeploymentRevision')
BEGIN
CREATE NONCLUSTERED INDEX nc7DeploymentRevision ON dbo.tbDeployment(RevisionID,
TargetGroupID, ActionID)
END
COMMIT TRAN
GO
[Note: the "create nonclusted" line probably word wrapped in this post... it
will need to be one long line ending with "ActionID)"]
3) Place the file in C:\Program Files\Update Services\Tools\osql.
4) Here's where is starts getting tricky. On the WSUS server, open the command
prompt and move to the directory you stored the file in. The command you need
to execute will generally be this:
osql -E -S %servername%\WSUS -n -b -i addDeploymentIndex.sql
where %servername% is the name of your WSUS server
Vielleicht hilft das für die Synchronisation.