Reporting database refresh (Project Server 2010) RRS feed

  • Question

  • Is the custom field backup/restore process the only way to trigger a rebuild of the reporting database? Is it correct that it deletes all of the data first? Does it affect only the reporting database?
    Monday, October 8, 2012 9:39 PM


  • Yes, that’s the only easy way. You may able to partially achieve this re-saving each lookup table, enterprise custom fields, views and resources. During RDb refresh followings jobs are executed

      • Fiscal Periods Sync
      • Lookup Table Sync
      • Custom Field Metadata Sync
      • Entity User View Refresh
      • Resources.

    RDB refresh is the process of updating data from Published database to Reporting database.

    To perform this job accurately, RDB refresh job has to empty existing data from rdb refresh which allows avoiding duplication or conflict of data during RDB refresh

    Hope this helps

    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Please click Mark As Answer; if a post solves your problem or Vote As Helpful; if a post has been useful to you.This can be beneficial to other community members reading the thread.

    Tuesday, October 9, 2012 1:55 AM