I just needed to move the System Center Operations Manager 2007 Database from one SQL server to another.
I followed Kevin Holman’s instructions step by step and ran into the same problem he was noticing after the move.
The error I got was:
Error 777971002, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.
So I followed the steps he took which did not solve my problem. I still got these errors in the log. But there is another way to fix this – here is my solution to the problem:
- Login to your SQL Machine
- Insert SCOM 2007 disc
- Navigate to D:\SupportTools\AMD64 (or whatever your cd drive and your platform is)
- Run DBCreateWizard.exe
- On the Database Information page choose your existing OperationsManager database and clear the “Create New Database” checkbox
- Fill in all other information according to your environment
- Finish the wizard
This will take a few minutes. After that the problem should be fixed.
This article relates my issue. Thanks for posting :)
However, one question.
Will there be data loss?? suppose if the DB is already functional n we happen to you the above method.
Will it not reset the tables too?
Even if I did not experience any problems or data loss I would always recommend taking a backup and being prepared for such events. What I think happens is that the wizard will only recreate any missing parts.
I am getting the same error in SCOM 2012 R2 server. As we don’t have DBCreateWizard support tool, what will be the option here?
I have the same problem with SCOM 2016. What can i do?