heysel
Goto Top

Sharepoint 2010 nach SP1 fertig installieren

Hallo zusammen,

nach der installation von Sharepoint 2010 muss man diesen Fertig installieren, sonst wirft er nach der installation im Ereignis LOG fehler aus. Das macht sich bemerkbar in nicht mehr funktionierenden Datensicherungen oder Windows Updates.

Folgendes muss gemacht werden:

1 Sharepoint Verwaltungs Powershell als Administrator öffnen

2 hier hin navigieren C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN

3 Folgendes eingeben PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

Content-Key: 174341

Url: https://administrator.de/contentid/174341

Ausgedruckt am: 29.03.2024 um 11:03 Uhr

Mitglied: battl1984
battl1984 10.10.2011 um 10:59:38 Uhr
Goto Top
Leider ist das noch nicht alles...

Um noch einen Fehler aus dem Ereignis-Log von SharePoint zu bekommen muss eine fehlende Tabelle in der SharePoint SQL-DB ergänzt werden.

Dazu folgendes tun:

1. Das SQL Server Management Studio aufrufen (Wichtig als Administrator ausführen, sonst geht es nicht!)
2. Mit der SharePoint Datenbank verbinden
3. Folgenden Befehl zum suchen ausführen:

exec sp_msforeachdb 'if exists(select name from [?].sys.objects where type = ''P'' and name like ''%proc_UpdateStatistics%'') AND not exists(select name from [?].sys.objects where type = ''P'' and name like ''%proc_UpdateStatisticsNVP%'') select ''?'''  

4. Das Ergebnis oben im Dropdown-Menü auswählen und dann folgenden, ewig langen, Befehl ausführen (vorzugsweise über Copy und Paste face-wink:

___________________________________________________________________________________________________________________________________________
/****** Object:  StoredProcedure [dbo].[proc_UpdateStatisticsNVP]    Script Date: 08/12/2011 10:22:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[proc_UpdateStatisticsNVP]
AS
    SET NOCOUNT ON
    DECLARE @command varchar(8000)
    IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Value' AND object_id = object_id(N'[dbo].[NameValuePair]'))  
    BEGIN
        PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePair_Value are now being updated with default sampling.'          
        SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair] NameValuePair_Value'      
        PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
        EXEC (@command)
        PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'  
    END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Albanian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Albanian_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairAlbanian_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Albanian_CI_AS] NameValuePair_Albanian_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Arabic_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Arabic_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairArabic_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Arabic_CI_AS] NameValuePair_Arabic_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_PRC_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_PRC_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_PRC_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_PRC_CI_AS] NameValuePair_Chinese_PRC_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_PRC_Stroke_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_PRC_Stroke_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_PRC_Stroke_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_PRC_Stroke_CI_AS] NameValuePair_Chinese_PRC_Stroke_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_Taiwan_Bopomofo_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS] NameValuePair_Chinese_Taiwan_Bopomofo_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_Taiwan_Stroke_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_Taiwan_Stroke_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_Taiwan_Stroke_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_Taiwan_Stroke_CI_AS] NameValuePair_Chinese_Taiwan_Stroke_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Croatian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Croatian_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairCroatian_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Croatian_CI_AS] NameValuePair_Croatian_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Cyrillic_General_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Cyrillic_General_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairCyrillic_General_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Cyrillic_General_CI_AS] NameValuePair_Cyrillic_General_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Czech_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Czech_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairCzech_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Czech_CI_AS] NameValuePair_Czech_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Danish_Norwegian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Danish_Norwegian_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairDanish_Norwegian_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Danish_Norwegian_CI_AS] NameValuePair_Danish_Norwegian_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Estonian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Estonian_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairEstonian_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Estonian_CI_AS] NameValuePair_Estonian_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Finnish_Swedish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Finnish_Swedish_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairFinnish_Swedish_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Finnish_Swedish_CI_AS] NameValuePair_Finnish_Swedish_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_French_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_French_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairFrench_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_French_CI_AS] NameValuePair_French_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Georgian_Modern_Sort_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Georgian_Modern_Sort_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairGeorgian_Modern_Sort_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Georgian_Modern_Sort_CI_AS] NameValuePair_Georgian_Modern_Sort_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_German_PhoneBook_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_German_PhoneBook_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairGerman_PhoneBook_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_German_PhoneBook_CI_AS] NameValuePair_German_PhoneBook_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Greek_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Greek_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairGreek_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Greek_CI_AS] NameValuePair_Greek_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Hebrew_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Hebrew_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairHebrew_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Hebrew_CI_AS] NameValuePair_Hebrew_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Hindi_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Hindi_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairHindi_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Hindi_CI_AS] NameValuePair_Hindi_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Hungarian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Hungarian_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairHungarian_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Hungarian_CI_AS] NameValuePair_Hungarian_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Hungarian_Technical_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Hungarian_Technical_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairHungarian_Technical_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Hungarian_Technical_CI_AS] NameValuePair_Hungarian_Technical_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Icelandic_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Icelandic_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairIcelandic_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Icelandic_CI_AS] NameValuePair_Icelandic_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Japanese_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Japanese_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairJapanese_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Japanese_CI_AS] NameValuePair_Japanese_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Japanese_Unicode_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Japanese_Unicode_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairJapanese_Unicode_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Japanese_Unicode_CI_AS] NameValuePair_Japanese_Unicode_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Korean_Wansung_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Korean_Wansung_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairKorean_Wansung_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Korean_Wansung_CI_AS] NameValuePair_Korean_Wansung_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Korean_Wansung_Unicode_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Korean_Wansung_Unicode_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairKorean_Wansung_Unicode_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Korean_Wansung_Unicode_CI_AS] NameValuePair_Korean_Wansung_Unicode_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Latin1_General_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Latin1_General_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairLatin1_General_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Latin1_General_CI_AS] NameValuePair_Latin1_General_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Latvian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Latvian_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairLatvian_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Latvian_CI_AS] NameValuePair_Latvian_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Lithuanian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Lithuanian_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairLithuanian_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Lithuanian_CI_AS] NameValuePair_Lithuanian_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Lithuanian_Classic_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Lithuanian_Classic_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairLithuanian_Classic_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Lithuanian_Classic_CI_AS] NameValuePair_Lithuanian_Classic_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Traditional_Spanish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Traditional_Spanish_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairTraditional_Spanish_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Traditional_Spanish_CI_AS] NameValuePair_Traditional_Spanish_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Modern_Spanish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Modern_Spanish_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairModern_Spanish_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Modern_Spanish_CI_AS] NameValuePair_Modern_Spanish_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Polish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Polish_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairPolish_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Polish_CI_AS] NameValuePair_Polish_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Romanian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Romanian_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairRomanian_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Romanian_CI_AS] NameValuePair_Romanian_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Slovak_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Slovak_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairSlovak_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Slovak_CI_AS] NameValuePair_Slovak_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Slovenian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Slovenian_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairSlovenian_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Slovenian_CI_AS] NameValuePair_Slovenian_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Thai_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Thai_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairThai_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Thai_CI_AS] NameValuePair_Thai_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Turkish_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Turkish_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairTurkish_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Turkish_CI_AS] NameValuePair_Turkish_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Ukrainian_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Ukrainian_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairUkrainian_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Ukrainian_CI_AS] NameValuePair_Ukrainian_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Vietnamese_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Vietnamese_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairVietnamese_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Vietnamese_CI_AS] NameValuePair_Vietnamese_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Azeri_Cyrillic_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Azeri_Cyrillic_90_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairAzeri_Cyrillic_90_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Azeri_Cyrillic_90_CI_AS] NameValuePair_Azeri_Cyrillic_90_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Azeri_Latin_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Azeri_Latin_90_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairAzeri_Latin_90_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Azeri_Latin_90_CI_AS] NameValuePair_Azeri_Latin_90_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Chinese_Hong_Kong_Stroke_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Chinese_Hong_Kong_Stroke_90_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairChinese_Hong_Kong_Stroke_90_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Chinese_Hong_Kong_Stroke_90_CI_AS] NameValuePair_Chinese_Hong_Kong_Stroke_90_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Divehi_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Divehi_90_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairDivehi_90_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Divehi_90_CI_AS] NameValuePair_Divehi_90_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Indic_General_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Indic_General_90_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairIndic_General_90_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Indic_General_90_CI_AS] NameValuePair_Indic_General_90_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Kazakh_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Kazakh_90_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairKazakh_90_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Kazakh_90_CI_AS] NameValuePair_Kazakh_90_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Macedonian_FYROM_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Macedonian_FYROM_90_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairMacedonian_FYROM_90_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Macedonian_FYROM_90_CI_AS] NameValuePair_Macedonian_FYROM_90_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Syriac_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Syriac_90_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairSyriac_90_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Syriac_90_CI_AS] NameValuePair_Syriac_90_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Tatar_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Tatar_90_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairTatar_90_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Tatar_90_CI_AS] NameValuePair_Tatar_90_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
        IF EXISTS(SELECT 1 FROM sys.stats WHERE name = N'NameValuePair_Uzbek_Latin_90_CI_AS_Value' AND object_id = object_id(N'[dbo].[NameValuePair_Uzbek_Latin_90_CI_AS]'))  
        BEGIN
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Statistics for NameValuePairUzbek_Latin_90_CI_AS_Value are now being updated with default sampling.'   
            SELECT @command = N'UPDATE STATISTICS [dbo].[NameValuePair_Uzbek_Latin_90_CI_AS] NameValuePair_Uzbek_Latin_90_CI_AS_Value'  
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Rebuilding'  
            EXEC (@command)
            PRINT CONVERT(nvarchar, GETDATE(), 126) + ': Done'   
        END
    RETURN 0
___________________________________________________________________________________________________________________________________________

5. Das war es schon face-smile


Allerdings gibt es ja noch die VSS-Warungen des SPfarm-Users....

Weiß jemand was hier zu tun ist damit diese Warnungen nicht mehr auftreten?

VG
Battl
Mitglied: free2kstyler
free2kstyler 11.10.2011 um 01:10:33 Uhr
Goto Top
Hoi,

also soweit läuft jetzt auch alles... verdammtes SP1 Update wie können die Sowas nur raus bringen ???????

Ich hab noch hier den Fehler und komm leider nicht dahinter wie ich ihn weg bekomme...


Volumeschattenkopie-Dienstfehler beim Auflösen des Kontos "spsearch" mit dem Status "1376". Überprüfen Sie die Verbindung mit dem Domänencontroller und den Registrierungsschlüssel "VssAccessControl".

Fehlerspezifische Details:
Fehler: NetLocalGroupGetMemebers(spsearch), 0x80070560, Die angegebene lokale Gruppe ist nicht vorhanden.


hat von euch einer eine Idde?

Viele Grüße
Marcel
Mitglied: battl1984
battl1984 11.10.2011 um 08:09:07 Uhr
Goto Top
ja ja den Quatsch kenne ich auch face-smile

Ich habe keine Ahnung! Aber es gibt leider so viele Fehler aus dem Erignis-Log von dem Microsoft selbst sagt das der Fehler bedenkenlos ignorierten werden kann... Ich bin es leid ewig viel Zeit in die Fehlerbehebung zu investieren wenn der Server läuft! Ich finde nur Microsoft könnte mal Updates raus bringen damit die Fehler nicht mehr erzeugt werden, wenn sie schon ignoriert werden können!!

VG
battl
Mitglied: jadefalke
jadefalke 09.02.2012 um 11:18:42 Uhr
Goto Top
Zitat von @free2kstyler:
Hoi,

also soweit läuft jetzt auch alles... verdammtes SP1 Update wie können die Sowas nur raus bringen ???????

Ich hab noch hier den Fehler und komm leider nicht dahinter wie ich ihn weg bekomme...


Volumeschattenkopie-Dienstfehler beim Auflösen des Kontos "spsearch" mit dem Status "1376".
Überprüfen Sie die Verbindung mit dem Domänencontroller und den Registrierungsschlüssel
"VssAccessControl".

Fehlerspezifische Details:
Fehler: NetLocalGroupGetMemebers(spsearch), 0x80070560, Die angegebene lokale Gruppe ist nicht vorhanden.


hat von euch einer eine Idde?

Viele Grüße
Marcel

Ich habe auch alles Versucht um den VSS Fehler zu beseitigen, bis dato kein Erfolg.
Es wird empfohlen die SPFarm und SPSearch Konto aus dem Registryschlüssel VSSACCESSCONTROL zu entfernen.
Habe ich gemacht. VSS Fehler vorhanden
Es wird empfohlen die SPFarm und SPSearch Konto aus dem Registryschlüssel VSSACCESSCONTROL auf 0 zu setzen
Habe ich gemacht. VSS Fehler vorhanden

Zusätzlich ist es so dass ich auf dem SBS keine WIndows Sicherung laufen haben, da ich mit Symantec Backup Exec Sichere. Also woher kommt der Backup im Eventlog?
Ist jemand hier weitergekommen?
Mitglied: jadefalke
jadefalke 24.02.2012 um 17:07:16 Uhr
Goto Top
nun in der Zwischenzeit hatte ich die Möglichkeit einen weiteren SBS 2011 Server zu installieren.

Der Fehler tritt sofort nach der Vollendung der Installation.

Es wird empfohlen folgende Reihenfolge einzuhalten.

Nach der Installation von SBS2011 sollte der Server upgedatet werden.
1. Servicepack 1 für Windows 2008 R2 installieren
2. Sharepoint 2010 ServicePack 1 installieren
3. PSConfig im CMD (mit AdminRechten) ausführen
4. mindesten das Sharepoint kumulative Update für August 2011 installieren (dieses Update muss mit Angabe einer eMail Adresse von MS rutnergeladen werden)
5. Als letztes den Konfigurations-Assistenten für Sharepoint durchlaufen lassen

Aus dem Registry Schlüssel VSSACCESSControl sollte SPFarm und SPSearch entfernt werden.
Serverneustart

PS:
Zum besseren Verständnis.
Führt man den Konfigurations Assistenen für Sharepoint 2010 aus, werden auch alle Dienste für Sharepoint unter einem Sharepoint Account gestartet. Diese sind SPFARM und SPSEARCH

Führt man die oberen Schritte durch, bekommt man in der Ereignissanzeige keine Warnung mehr, sondern ein Fehler.
Der Fehler mit EreignisID 8213 VSS besagt dass ein Sharepoint Dienst, in meinem Fall war es Sharepoint 2010 VSS Writer mit einem Account gestartet wurde der zu geringe Berechtigungen hat. Es wird darauf hingewiesen man sollte den Dienst unter einem lokalen Dienstkonto oder Administrator ausführen.
Ändert man die Anmeldedaten des Diensten von Domäne/SPFARM auf lokalen Dienst oder Administratokonto, erhält man wieder den oberen Fehler mit dem VSSACCESSControl Regschlüssel.

Jetzt kommt das witzige an der ganzen Sache. Gebe ich den User SPFARM und SPSEARCH administrative Rechte, so bekomm ich die Fehlermeldung dass diese beiden Konten aus Sicherheitsgründen keine administrativen Rechte haben sollen.

Ich bin am Ende.Schade um die Hardware, aber SBS2011 schmeiss ich ausm Fenster.