HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

SIM 5.1 SQL DB shows suspect

 
cybercoaster
Frequent Advisor

SIM 5.1 SQL DB shows suspect

I upgraded our SIM to 5.1 sp1 just recently. I didnt get a backup ran and now the Insight_v50_0_94153500 database shows suspect.

The event log shows Event ID 3. com.hp.mx.database.DBVerificationException

I have a backup from before the upgrade of the database. Can I restore the old database or were there to many changes made with 5.1 to the tables? Can I restore the old database and then install 5.1 again on top of itself?

Or, would it be better just to deinstall SIM all together and just start new again. I really dont have many custom items configured and could do another discovery.

What are my options here?
2 REPLIES
Simon_178
Honored Contributor

Re: SIM 5.1 SQL DB shows suspect

Kevin,

Generally speaking a db marked suspect
can be marked for many reasons.

Generally it may fall into the following conditions
1) A database or log file is missing.
2) In SQL 6.x, a device may not be present or in 7.0/2000 a file may not exist.
3) SQL Server may not have been able to restore the database in ample time.
4) The database could be corrupt.
5) SQL Server does not have enough space to recover the database on startup.

Have you checked the above options via the SQL Log files

Simon
Simon_178
Honored Contributor

Re: SIM 5.1 SQL DB shows suspect

Kevin,

To answer the other half of your question, if you have time and there is little to be lost in the reinstallation process perhaps this would be the best option. It depends on your situation.

Otherwise you can try and restore from a previous backup.

Simon