locked
Is there any way to rebuild warehouse for specific collection Instead entire TFS Instance RRS feed

  • Question

  • Hi Team,

    We have detached and attached collection and found there is issues with Warehouse for this collection.

    We are using TFS 2015 update 3. All the project data under this specific collection is showing as deleted?

    We are in a position not to build entire TFS as it takes long time and effects other users collection.

    Please let us know the best way what we can do to create schema and data will show with respect to this collection (Which is detached and attached)?

    Thanks,

    Raj


    Rajesh

    Tuesday, August 1, 2017 6:13 AM

Answers

  • Hi Raj,

    I do not believe it is possible to do that. You can rebuild only analysis services database if required by specifying /analysisServices , but in your case you should rebuild entire warehouse since you have collection attach detach happened.  TFS warehouse rebuild will not cause any issue other than unavailability of reports until it completes.

    But I do not think there is a way to do rebuild only for a given collection as there is only one tfs_Warehouse DB containing all collections data.

    Refer below link for  more information on command line rebuild.

    https://www.visualstudio.com/en-us/docs/setup-admin/tfs/command-line/tfsconfig-cmd#rebuildwarehouse

    Cheers!

    Chaminda

    • Marked as answer by Raj_Rajesh Tuesday, August 1, 2017 10:01 AM
    Tuesday, August 1, 2017 7:56 AM
  • Hi Chaminda,

    Thanks for your reply. Yes, we cannot do entire rebuild again this is the issue for us as reports wont available for all other teams (collections).

    Thanks,

    Raj


    Raj

    • Marked as answer by Raj_Rajesh Tuesday, August 1, 2017 10:04 AM
    Tuesday, August 1, 2017 10:01 AM

All replies

  • Hi Raj,

    I do not believe it is possible to do that. You can rebuild only analysis services database if required by specifying /analysisServices , but in your case you should rebuild entire warehouse since you have collection attach detach happened.  TFS warehouse rebuild will not cause any issue other than unavailability of reports until it completes.

    But I do not think there is a way to do rebuild only for a given collection as there is only one tfs_Warehouse DB containing all collections data.

    Refer below link for  more information on command line rebuild.

    https://www.visualstudio.com/en-us/docs/setup-admin/tfs/command-line/tfsconfig-cmd#rebuildwarehouse

    Cheers!

    Chaminda

    • Marked as answer by Raj_Rajesh Tuesday, August 1, 2017 10:01 AM
    Tuesday, August 1, 2017 7:56 AM
  • Hi Chaminda,

    Thanks for your reply. Yes, we cannot do entire rebuild again this is the issue for us as reports wont available for all other teams (collections).

    Thanks,

    Raj


    Raj

    • Marked as answer by Raj_Rajesh Tuesday, August 1, 2017 10:04 AM
    Tuesday, August 1, 2017 10:01 AM