Identity Manager Community

Forum One Identity Manager Database going to suspect mode

State Not Answered
Locked Locked
Replies 4 replies
Subscribers 93 subscribers
Views 1875 views
Users 0 members are here

Options

Related

This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

One Identity Manager Database going to suspect mode

Nur over 4 years ago

Hi Experts

recently, I have upgraded my lab 1IM database from 8.0.2 to 8.1 after that I noticed the database going to suspect mode for no reason.

I restore the database from my backup however one day after I again found database is in suspect mode. Have any one noticed this?

Any resolution would be appreciated?

0 Markus Weiss-Ehlers over 4 years ago

Suspect mode from SQL Server? Which version?
Cancel
Up 0 Down

Cancel
0 Nur over 4 years ago in reply to Markus Weiss-Ehlers

yes. If I open up the sql management studio it shows the db is in suspect mode. I am using sql server 2016 SP2 (13.0.5026.0)
Cancel
Up 0 Down

Cancel
0 Markus Weiss-Ehlers over 4 years ago in reply to Nur

The system requirements for 8.1 https://support.oneidentity.com/de-de/technical-documents/identity-manager/8.1/release-notes/3#TOPIC-1139229 specify the for the latest CU for SQL 2016 SP2 to be required.

I know for sure that you need at least SQL 2016 SP2 CU4 due to some issues in SQL Server in combination with features used by 8.1
Cancel
Up 0 Down

Cancel
0 Nur over 4 years ago in reply to Markus Weiss-Ehlers

Cool. Thanks Markus. I will update the db and see how it goes.
Cancel
Up 0 Down

Cancel