Video Screencast Help

Cannot determine the SEPM database schema

Created: 11 Dec 2013 • Updated: 13 Dec 2013 | 19 comments
This issue has been solved. See solution.

I am running SEPM 12.1.4 on a Windows Server 2008 R2 machine. I had to do a disaster recovery and reinstall the SEPM. I followed the directions for preparing for disaster recovery. I backed up the database and the disaster recovery file. The SEPM installs fine but I am receiving an error during the Management Server Configuration. In Step Two: Existing Database Parameters I input the Dtatabase name, user name and password. When I click Next I receive the error below.

12-11-2013 2-11-05 PM.png

 

Any idea why I would be receiving this error?

 

Thank you.

 

Operating Systems:

Comments 19 CommentsJump to latest comment

.Brian's picture

Was the previous SEPM install on an older version or was it 12.1.4?

This new one needs to be on the same version of the one you created the backup from.

 

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

.Brian's picture

Do you have another backup you can try?

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

AravindKM's picture

Can you try with previous backup once?

Please don't forget to mark your thread solved with whatever answer helped you : ) Thanks & Regards Aravind

bspore's picture

I've tried with a previous backup and receive the same error. 

When the Management Server Configuration Wizard runs I am choosing Install an additional management server to an existing site. I should have mentioned before I have two management servers running. The server I had to do disaster recovery on was the primary SEPM. I can choose Install my first site and use an existing Microsoft SQL Server databse but I receive the message The specified database contains user data. Installing a new site will clear all existing data. I do not want to do this because I do not want to clear all existing data.

AravindKM's picture

You have to chose  Install my first site option only. Since you freshly installed it and the current database do not have any data, you can safely click ok to the message "The specified database contains user data. Installing a new site will clear all existing data".

Please don't forget to mark your thread solved with whatever answer helped you : ) Thanks & Regards Aravind

bspore's picture

If I choose Install my first site won't this clear all data from the database? There was data in the database from when I first install SEPM 12.1. I just want to make sure I won't loose any of the policies and group structure I had setup in the SEPM.

AravindKM's picture

As far as I understand your the scenario is this.

You have backup of your primary SEPM.

You have reinstalled SEPM software. So currently there is no data present in the server.

 

If above is your scenario you can select option to clear all your previous data because

When you install and configure SEPM, it will create a database. This will have the only information what all you provided during the installation. But your backup will have all data from the fist installation to the backup date. Once you select the option to overwrite, all data which is present in the backup will be restored to the server. So you will not lose any data which is really needed.

Please don't forget to mark your thread solved with whatever answer helped you : ) Thanks & Regards Aravind

bspore's picture

I cleared all previous data. Now when I do a restore of the database I receive the error below.

12-12-2013 9-50-51 AM.png

I have tried different backup files from the Server Private Key Backup folder.

SameerU's picture

Hi

Can you check whether there are any remaining instances of previous database

Regards

 

Beppe's picture

Hello,

did you backup the DB by using the SEPM DB backup wizard?

Regards,

Giuseppe

bspore's picture

Yes. I followed the Preparing for disaster recovery steps.

Beppe's picture

they were 2 SEPMs and 1 SQL DB, correct?

Regards,

Giuseppe

bspore's picture

Yes, that is correct. I have two SEPMs, one primary, one secondary, no replication. They are connected to one database.

Beppe's picture

I agree with you that it was enough to "add a SEPM to an existing site", no need to reset the DB and then restore it again when the issue were isolated to a single SEPM (was the other SEPM still working, right?).

Just one minor note about the terminology you use here, in such architecture there's no primary or secondary SEPM, you may call them in such way for your convenience and based on how you use them but it is not technically relevant.

Coming back to your issue, at this point you should contact the Technical Support to get more advanced troubleshooting.

Regards,

Giuseppe

SOLUTION
bspore's picture

I am unable to log into the other SEPM. When I try to log into the other SEPM I receive the error Failed to connect to the server. I can log into SEPM I reinstalled but all the policies, grouping structure and settings I configured before are all gone. When I go to Admin > Servers I only see one SEPM listed, which is the one I reinstalled SEPM on. I do not see an option to add the other SEPM. 

Beppe's picture

Hello,

 

sorry for the delay, I was not connected.

The option to add another SEPM is offered during the installation o a new SEPM.

I am sorry you lost your data, you should be able to restore them from the DB backup.

If you are still in troubles, please, submit a ticket to our support service.

Regards,

Giuseppe

AjinBabu's picture

Hello, 

Have you tried repairing option of not please do a repair and keep posted.

Regards

Ajin