none
Не удаляются файлы из BLOB SharePoint 2010 RRS feed

  • Вопрос

  • Добрый день настроил BLOB

    http://technet.microsoft.com/en-us/library/ee748631.aspx

    Добавил в библиотеку несколько файлов  1 Мб , 10 Мб, 20 Мб

    Затем удалил файлы и решил проверить удалились ли файлы из F:\BLOBStorage\ и оказалось что нет...

    Кто подскажет как победить данную проблему?

    26 июня 2012 г. 13:43

Ответы

  • Добрый день настроил BLOB

    http://technet.microsoft.com/en-us/library/ee748631.aspx

    Добавил в библиотеку несколько файлов  1 Мб , 10 Мб, 20 Мб

    Затем удалил файлы и решил проверить удалились ли файлы из F:\BLOBStorage\ и оказалось что нет...

    Кто подскажет как победить данную проблему?

    Настроил maintain

    для БД контента  выполнил

    exec mssqlrbs.rbs_sp_set_config_value 'delete_scan_period','time 00:00:00'
    exec mssqlrbs.rbs_sp_set_config_value 'orphan_scan_period','time 00:00:00'
    exec mssqlrbs.rbs_sp_set_config_value 'garbage_collection_time_window','time 00:00:00'

    Далее настроил коннектор но как отработало только один раз и все причем не сразу а через какое то время... Не пойму что не так....

    1.       For each content Database that is RBS enabled :Add content database connection string to the Microsoft.Data.SqlRemoteBlobs.Maintainer.exe.config file
    a.       Rename the existing config file to web.config using following command (located in %programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer )

    cd /d %programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer

    ren Microsoft.Data.SqlRemoteBlobs.Maintainer.exe.config web.config

    b.      Un-encrypt the connection strings from the config file by using following command (aspnet_regiis is located in %windir%\Microsoft.NET\Framework64\v2.0.50727

    cd /d %windir%\Microsoft.NET\Framework64\v2.0.50727

    aspnet_regiis.exe -pdf connectionStrings "%programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer"

    c.       Add additional connection string to the web.config file for each content database that is rbs enabled like following . Change the name of connection string , data source and Initial Catalog as needed

        <connectionStrings>

            <add connectionString="Data Source=localhost;Initial Catalog=RemoteBlobStorage;Integrated Security=True;Application Name=&quot;Remote Blob Storage Maintainer&quot;"
                providerName="System.Data.SqlClient" />

            <add connectionString="Data Source=wsslab40;Initial Catalog=wss_content;Integrated Security=True;Application Name=&quot;Remote Blob Storage Maintainer for WSS_Content&quot;"
                providerName="System.Data.SqlClient" />

        </connectionStrings>\
        
        Dobavlat nado tak!!!!!
        
        <configuration>
      <connectionStrings configProtectionProvider="DataProtectionConfigurationProvider">
        <EncryptedData>
          <CipherData>
            <CipherValue>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAGl75prAS2USRn38iG8YkaQQAAAACAAAAAAAQZgAAAAEAACAAAAD216BMWRmnj787qVwSDrgmcLZnQom+zJHCjVPO8m5NMAAAAAAOgAAAAAIAACAAAACm0Wv3xlAE6qhUR1qtpfjNI98M6vhPrRWSFgHKrEq5FUACAACehWQcNkP+5lZnVRp8Lr/oLO/cfTSiKY3wedybOTIwF30ZWIIAL8j2pSSWJHyyeAXK+mYuYjZB7zZeat2cKsK3NiKEoMi9X6BUEtXZIvgNYf1I3fb2Go6Doxr+m1DbZfqp8fbQFVHhno1NJcDXD+lE+3eteOG2AjsCGRJS03Qaa+LNOpM+Z+qljZXRmI1fVc5ZJiNKy/m6WweNzmImU8GDe49TcpGpoRbYe7tgJy5m+sU9Z+9y7pZplAiV9OT/YQasFK+Lx/5Kt6hqBcqbnUow/qW3fzg092hqzlfIDdxgC9HlYyTQKSkAnKS6WX5vO1GwX50EypV8YqWU6QaIONEZTM5HLdMXSTLC4oCZZbGi0SOGIAw3rTstnD+RjnSZD1PM+UeXXcPvBQsNzeCCODIMGFb1pI7dBfOJlB4BMcmDRIb4JxRil3qg49DYkM4y2Y2nOrl2s19wIAMuyXfDe9Fx6+giBcUgousc0qTxNQu/XLewDqubDaeP8zlJIJo3XqbUfeP/4Mm5QqSXhix3M+9WmJmFU66OccEzrsrX3yIqUw3Yxpa9+XlxQY2FqMsbfuzRkr4prWYXOMfobedkx7tqXWGWQrvl36M3batDcHkQHAwRc04QMpiZPA29FckGxGBQ6SjfLp/aKimQq2ElcTxhmJcr5ZsjCU+8xSkJJLAAmtr9E0oPZ7vx/9QzjssMxFFjw3i6eP8dUNuSkL/258ki2kWO7Q+rV5WvsgpN+g+j/u50teBKOT6CUAfRKtVAD5BAAAAAUpuaG8nTSMgaxtI1PVZrcfyYlft/lHwkAmdogEEFRh+DSCrhVGcf8z/o8CpaCBgVtw0cEiCAK85YxAy6zefHHw==</CipherValue>
          
          <CipherValue> <add connectionString="Data Source=localhost;Initial Catalog=RemoteBlobStorage;Integrated Security=True;Application Name=&quot;Remote Blob Storage Maintainer&quot;"
                providerName="System.Data.SqlClient" />

            <add connectionString="Data Source=wsslab40;Initial Catalog=wss_content;Integrated Security=True;Application Name=&quot;Remote Blob Storage Maintainer for WSS_Content&quot;"
                providerName="System.Data.SqlClient" /></CipherValue>
          
          </CipherData>
        </EncryptedData>
      </connectionStrings>



        <RemoteBlobStorage>
            <Logging>
                <add key="ConsoleLog" value="0" />
            </Logging>
        </RemoteBlobStorage>
    </configuration>



    d.      Encrypt the web.config file again by using following command

    cd /d %windir%\Microsoft.NET\Framework64\v2.0.50727

    aspnet_regiis -pef connectionStrings "%programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer " -prov DataProtectionConfigurationProvider

    e.      Rename the file back to original

    cd /d %programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer

    ren web.config Microsoft.Data.SqlRemoteBlobs.Maintainer.exe.config

     Note: XML file is case sensitive, you need to use the exact string for 'connectionStrings' parameter above.

    2.       Create a Maintenance Task using following steps (for each database) or run command


    Microsoft.Data.SqlRemoteBlobs.Maintainer.exe -ConnectionStringName RBSMaintainerConnection -Operation GarbageCollection ConsistencyCheck ConsistencyCheckForStores -GarbageCollectionPhases rdo -ConsistencyCheckMode r -TimeLimit 0

    Выполнил команду на БД Контента. Кто может сказть почему удаление возможно только после

    CHECKPOINT;

    27 июня 2012 г. 11:29

Все ответы

  • Добрый день настроил BLOB

    http://technet.microsoft.com/en-us/library/ee748631.aspx

    Добавил в библиотеку несколько файлов  1 Мб , 10 Мб, 20 Мб

    Затем удалил файлы и решил проверить удалились ли файлы из F:\BLOBStorage\ и оказалось что нет...

    Кто подскажет как победить данную проблему?

    Настроил maintain

    для БД контента  выполнил

    exec mssqlrbs.rbs_sp_set_config_value 'delete_scan_period','time 00:00:00'
    exec mssqlrbs.rbs_sp_set_config_value 'orphan_scan_period','time 00:00:00'
    exec mssqlrbs.rbs_sp_set_config_value 'garbage_collection_time_window','time 00:00:00'

    Далее настроил коннектор но как отработало только один раз и все причем не сразу а через какое то время... Не пойму что не так....

    1.       For each content Database that is RBS enabled :Add content database connection string to the Microsoft.Data.SqlRemoteBlobs.Maintainer.exe.config file
    a.       Rename the existing config file to web.config using following command (located in %programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer )

    cd /d %programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer

    ren Microsoft.Data.SqlRemoteBlobs.Maintainer.exe.config web.config

    b.      Un-encrypt the connection strings from the config file by using following command (aspnet_regiis is located in %windir%\Microsoft.NET\Framework64\v2.0.50727

    cd /d %windir%\Microsoft.NET\Framework64\v2.0.50727

    aspnet_regiis.exe -pdf connectionStrings "%programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer"

    c.       Add additional connection string to the web.config file for each content database that is rbs enabled like following . Change the name of connection string , data source and Initial Catalog as needed

        <connectionStrings>

            <add connectionString="Data Source=localhost;Initial Catalog=RemoteBlobStorage;Integrated Security=True;Application Name=&quot;Remote Blob Storage Maintainer&quot;"
                providerName="System.Data.SqlClient" />

            <add connectionString="Data Source=wsslab40;Initial Catalog=wss_content;Integrated Security=True;Application Name=&quot;Remote Blob Storage Maintainer for WSS_Content&quot;"
                providerName="System.Data.SqlClient" />

        </connectionStrings>\
        
        Dobavlat nado tak!!!!!
        
        <configuration>
      <connectionStrings configProtectionProvider="DataProtectionConfigurationProvider">
        <EncryptedData>
          <CipherData>
            <CipherValue>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAGl75prAS2USRn38iG8YkaQQAAAACAAAAAAAQZgAAAAEAACAAAAD216BMWRmnj787qVwSDrgmcLZnQom+zJHCjVPO8m5NMAAAAAAOgAAAAAIAACAAAACm0Wv3xlAE6qhUR1qtpfjNI98M6vhPrRWSFgHKrEq5FUACAACehWQcNkP+5lZnVRp8Lr/oLO/cfTSiKY3wedybOTIwF30ZWIIAL8j2pSSWJHyyeAXK+mYuYjZB7zZeat2cKsK3NiKEoMi9X6BUEtXZIvgNYf1I3fb2Go6Doxr+m1DbZfqp8fbQFVHhno1NJcDXD+lE+3eteOG2AjsCGRJS03Qaa+LNOpM+Z+qljZXRmI1fVc5ZJiNKy/m6WweNzmImU8GDe49TcpGpoRbYe7tgJy5m+sU9Z+9y7pZplAiV9OT/YQasFK+Lx/5Kt6hqBcqbnUow/qW3fzg092hqzlfIDdxgC9HlYyTQKSkAnKS6WX5vO1GwX50EypV8YqWU6QaIONEZTM5HLdMXSTLC4oCZZbGi0SOGIAw3rTstnD+RjnSZD1PM+UeXXcPvBQsNzeCCODIMGFb1pI7dBfOJlB4BMcmDRIb4JxRil3qg49DYkM4y2Y2nOrl2s19wIAMuyXfDe9Fx6+giBcUgousc0qTxNQu/XLewDqubDaeP8zlJIJo3XqbUfeP/4Mm5QqSXhix3M+9WmJmFU66OccEzrsrX3yIqUw3Yxpa9+XlxQY2FqMsbfuzRkr4prWYXOMfobedkx7tqXWGWQrvl36M3batDcHkQHAwRc04QMpiZPA29FckGxGBQ6SjfLp/aKimQq2ElcTxhmJcr5ZsjCU+8xSkJJLAAmtr9E0oPZ7vx/9QzjssMxFFjw3i6eP8dUNuSkL/258ki2kWO7Q+rV5WvsgpN+g+j/u50teBKOT6CUAfRKtVAD5BAAAAAUpuaG8nTSMgaxtI1PVZrcfyYlft/lHwkAmdogEEFRh+DSCrhVGcf8z/o8CpaCBgVtw0cEiCAK85YxAy6zefHHw==</CipherValue>
          
          <CipherValue> <add connectionString="Data Source=localhost;Initial Catalog=RemoteBlobStorage;Integrated Security=True;Application Name=&quot;Remote Blob Storage Maintainer&quot;"
                providerName="System.Data.SqlClient" />

            <add connectionString="Data Source=wsslab40;Initial Catalog=wss_content;Integrated Security=True;Application Name=&quot;Remote Blob Storage Maintainer for WSS_Content&quot;"
                providerName="System.Data.SqlClient" /></CipherValue>
          
          </CipherData>
        </EncryptedData>
      </connectionStrings>



        <RemoteBlobStorage>
            <Logging>
                <add key="ConsoleLog" value="0" />
            </Logging>
        </RemoteBlobStorage>
    </configuration>



    d.      Encrypt the web.config file again by using following command

    cd /d %windir%\Microsoft.NET\Framework64\v2.0.50727

    aspnet_regiis -pef connectionStrings "%programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer " -prov DataProtectionConfigurationProvider

    e.      Rename the file back to original

    cd /d %programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer

    ren web.config Microsoft.Data.SqlRemoteBlobs.Maintainer.exe.config

     Note: XML file is case sensitive, you need to use the exact string for 'connectionStrings' parameter above.

    2.       Create a Maintenance Task using following steps (for each database) or run command


    Microsoft.Data.SqlRemoteBlobs.Maintainer.exe -ConnectionStringName RBSMaintainerConnection -Operation GarbageCollection ConsistencyCheck ConsistencyCheckForStores -GarbageCollectionPhases rdo -ConsistencyCheckMode r -TimeLimit 0

    27 июня 2012 г. 7:42
  • Добрый день настроил BLOB

    http://technet.microsoft.com/en-us/library/ee748631.aspx

    Добавил в библиотеку несколько файлов  1 Мб , 10 Мб, 20 Мб

    Затем удалил файлы и решил проверить удалились ли файлы из F:\BLOBStorage\ и оказалось что нет...

    Кто подскажет как победить данную проблему?

    Настроил maintain

    для БД контента  выполнил

    exec mssqlrbs.rbs_sp_set_config_value 'delete_scan_period','time 00:00:00'
    exec mssqlrbs.rbs_sp_set_config_value 'orphan_scan_period','time 00:00:00'
    exec mssqlrbs.rbs_sp_set_config_value 'garbage_collection_time_window','time 00:00:00'

    Далее настроил коннектор но как отработало только один раз и все причем не сразу а через какое то время... Не пойму что не так....

    1.       For each content Database that is RBS enabled :Add content database connection string to the Microsoft.Data.SqlRemoteBlobs.Maintainer.exe.config file
    a.       Rename the existing config file to web.config using following command (located in %programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer )

    cd /d %programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer

    ren Microsoft.Data.SqlRemoteBlobs.Maintainer.exe.config web.config

    b.      Un-encrypt the connection strings from the config file by using following command (aspnet_regiis is located in %windir%\Microsoft.NET\Framework64\v2.0.50727

    cd /d %windir%\Microsoft.NET\Framework64\v2.0.50727

    aspnet_regiis.exe -pdf connectionStrings "%programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer"

    c.       Add additional connection string to the web.config file for each content database that is rbs enabled like following . Change the name of connection string , data source and Initial Catalog as needed

        <connectionStrings>

            <add connectionString="Data Source=localhost;Initial Catalog=RemoteBlobStorage;Integrated Security=True;Application Name=&quot;Remote Blob Storage Maintainer&quot;"
                providerName="System.Data.SqlClient" />

            <add connectionString="Data Source=wsslab40;Initial Catalog=wss_content;Integrated Security=True;Application Name=&quot;Remote Blob Storage Maintainer for WSS_Content&quot;"
                providerName="System.Data.SqlClient" />

        </connectionStrings>\
        
        Dobavlat nado tak!!!!!
        
        <configuration>
      <connectionStrings configProtectionProvider="DataProtectionConfigurationProvider">
        <EncryptedData>
          <CipherData>
            <CipherValue>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAGl75prAS2USRn38iG8YkaQQAAAACAAAAAAAQZgAAAAEAACAAAAD216BMWRmnj787qVwSDrgmcLZnQom+zJHCjVPO8m5NMAAAAAAOgAAAAAIAACAAAACm0Wv3xlAE6qhUR1qtpfjNI98M6vhPrRWSFgHKrEq5FUACAACehWQcNkP+5lZnVRp8Lr/oLO/cfTSiKY3wedybOTIwF30ZWIIAL8j2pSSWJHyyeAXK+mYuYjZB7zZeat2cKsK3NiKEoMi9X6BUEtXZIvgNYf1I3fb2Go6Doxr+m1DbZfqp8fbQFVHhno1NJcDXD+lE+3eteOG2AjsCGRJS03Qaa+LNOpM+Z+qljZXRmI1fVc5ZJiNKy/m6WweNzmImU8GDe49TcpGpoRbYe7tgJy5m+sU9Z+9y7pZplAiV9OT/YQasFK+Lx/5Kt6hqBcqbnUow/qW3fzg092hqzlfIDdxgC9HlYyTQKSkAnKS6WX5vO1GwX50EypV8YqWU6QaIONEZTM5HLdMXSTLC4oCZZbGi0SOGIAw3rTstnD+RjnSZD1PM+UeXXcPvBQsNzeCCODIMGFb1pI7dBfOJlB4BMcmDRIb4JxRil3qg49DYkM4y2Y2nOrl2s19wIAMuyXfDe9Fx6+giBcUgousc0qTxNQu/XLewDqubDaeP8zlJIJo3XqbUfeP/4Mm5QqSXhix3M+9WmJmFU66OccEzrsrX3yIqUw3Yxpa9+XlxQY2FqMsbfuzRkr4prWYXOMfobedkx7tqXWGWQrvl36M3batDcHkQHAwRc04QMpiZPA29FckGxGBQ6SjfLp/aKimQq2ElcTxhmJcr5ZsjCU+8xSkJJLAAmtr9E0oPZ7vx/9QzjssMxFFjw3i6eP8dUNuSkL/258ki2kWO7Q+rV5WvsgpN+g+j/u50teBKOT6CUAfRKtVAD5BAAAAAUpuaG8nTSMgaxtI1PVZrcfyYlft/lHwkAmdogEEFRh+DSCrhVGcf8z/o8CpaCBgVtw0cEiCAK85YxAy6zefHHw==</CipherValue>
          
          <CipherValue> <add connectionString="Data Source=localhost;Initial Catalog=RemoteBlobStorage;Integrated Security=True;Application Name=&quot;Remote Blob Storage Maintainer&quot;"
                providerName="System.Data.SqlClient" />

            <add connectionString="Data Source=wsslab40;Initial Catalog=wss_content;Integrated Security=True;Application Name=&quot;Remote Blob Storage Maintainer for WSS_Content&quot;"
                providerName="System.Data.SqlClient" /></CipherValue>
          
          </CipherData>
        </EncryptedData>
      </connectionStrings>



        <RemoteBlobStorage>
            <Logging>
                <add key="ConsoleLog" value="0" />
            </Logging>
        </RemoteBlobStorage>
    </configuration>



    d.      Encrypt the web.config file again by using following command

    cd /d %windir%\Microsoft.NET\Framework64\v2.0.50727

    aspnet_regiis -pef connectionStrings "%programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer " -prov DataProtectionConfigurationProvider

    e.      Rename the file back to original

    cd /d %programfiles%\Microsoft SQL Remote Blob Storage 10.50\Maintainer

    ren web.config Microsoft.Data.SqlRemoteBlobs.Maintainer.exe.config

     Note: XML file is case sensitive, you need to use the exact string for 'connectionStrings' parameter above.

    2.       Create a Maintenance Task using following steps (for each database) or run command


    Microsoft.Data.SqlRemoteBlobs.Maintainer.exe -ConnectionStringName RBSMaintainerConnection -Operation GarbageCollection ConsistencyCheck ConsistencyCheckForStores -GarbageCollectionPhases rdo -ConsistencyCheckMode r -TimeLimit 0

    Выполнил команду на БД Контента. Кто может сказть почему удаление возможно только после

    CHECKPOINT;

    27 июня 2012 г. 11:29