Rebuilding Data Warehouse in SCSM

Question

We are experiencing some issues with our SCSM Data Warehouse and have decided to rebuild it. I am having trouble finding information on this topic online.

Can someone who has experience with this process provide me with the necessary steps or any helpful articles?

Thank you in advance.

Answer 1

Hello Tollan,

Rebuilding the SCSM Data Warehouse involves several steps:

Unregister the SCSM DW: This can be done in the SCSM Console or Powershell using the Unregister-SCDWSource command.

Deinstall the SCSM DW components: Go to Control Panel > Program and features on your DW management server (not the SM management server) and remove "Microsoft System Center Service Manager".

Delete the SCSM DW databases: This involves opening SSMS and deleting the following databases: CMDWData Mart, DWRepository, DWDataMart, DWStagingandConfig, OMDWDataMart, ReportServer, and ReportServerTempDB. Then switch to Analysis Service and remove DWASDataBase.

Install the SCSM DW components: On the SCSM Data Warehouse Management Server in the System Center Service Manager installation media, double-click the Setup.exe file. New SCSM DW databases will be created during this process.

Register SCSM DW in SCSM console: This completes the process.

Please note that you should backup the full SCSM environment first. Also, you have to install the latest CU/UR after the first sync with SM is finished.

Best Regards,

Wesley Li

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi,

Here is a detailed tutorial. Follow the instruction to point no. 14. Then take backup. If you run the sql server and DW management server on the same machine just take a snapshot/checkpoint. Then follow the tutorial and check how far you can go and update your question if any error occurs.