I just needed to move the System Center Operations Manager 2007 Database from one SQL server to another.
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.