Support::Rebuild SCOM 2012 R2 Dataware house Database

Hi Folks,

We have 2 Management server, 1 opsmanager, 1 datawarehousedb + reporting server, 1 acs server. Unfortunately our datawarehousedb server took a hit and database got corrupted. To add to injury we dont have a valid database backup. We have tried to repair the database and it repair all the errors expect catalog errors due to which database keep going into suspect mode. I would like to know if there is a way to rebuild datawarehouse database component of the scom 2012 r2 environment. Any assistance in this matter will be very helpful.

 

Regards,

nav

December 5th, 2014 1:30am

Hi There,

1. Uninstall Report Server role.

2. Blow away ReportServer and ReportServerTempDB and the reporting services website (or do ssrs reset)

3. Uninstall the Data Warehouse component (i.e., Delete the Data Warehouse database)

4. Install the Data Warehouse (i.e., create the data warehouse database)

5. Ensure SSRS is working in default state (you can get to http://localhost/reports without error). You'll need to use SSRS Configuration Tool.

6. Install the Report Server role

Refer : https://social.technet.microsoft.com/Forums/systemcenter/en-US/ca03b455-8c13-42a7-a810-8a63c913b527/scom-data-warehouse-database-uninstall-and-reinstall-procedures-in-production?forum=operationsmanagerreporting

Free Windows Admin Tool Kit Click here and download it now
December 5th, 2014 8:46am

Hi Gautam,

I have instead followed this link and was able to rebuild a new datawarehousedb.

http://www.3packetsofcrisps.com/2014/04/reset-scom-2012-data-warehouse-database.html

Regards,

Nav

December 5th, 2014 6:14pm

Hi Navdeep,

Nice to hear it worked.

Thanks.

Free Windows Admin Tool Kit Click here and download it now
December 6th, 2014 1:53am

Hi Navdeep,

I see the link you referred was working before but does not seem to work now.

Do you have the steps to rebuild a new datawarehouse you used in the link there ?

Can you provide them here please ?

May 28th, 2015 3:59pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics