Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SEPM 12.1 Repair Installation and restoring Database using MS SQL

Created: 10 Feb 2013 • Updated: 25 Feb 2013 | 8 comments
cetnamys19's picture
This issue has been solved. See solution.

Hi all,

Scenario: Unable to log in in SEPM server after repair install.

I need to know how to restore the MS SQL DB after repairing the SEPM.

SEPM version: 12.1

SQL: MS SQL.

Is SEPM DB Backup and restore will run on MS SQL?

Thanks and Regards,

N

Comments 8 CommentsJump to latest comment

Ashish-Sharma's picture

Check this

Symantec Endpoint Protection Manager database backup and restore explained

Article:TECH183174 | Created: 2012-03-07 | Updated: 2012-07-28 | Article URL http://www.symantec.com/docs/TECH183174

Thanks In Advance

Ashish Sharma

SOLUTION
cetnamys19's picture

Thanks for the quick response. I'll try to use SEPM DB restore using the DB backup in data\backup\

Ajit Jha's picture

Question rises, did u had a SEPM Back up of Embedded Database or SQL, if SQL then use the link below for your reference

http://www.symantec.com/business/support/index?pag...

If you had Embedded Database then,

http://www.symantec.com/business/support/index?pag...

Regard's

Ajit Jha

Technical Consultant

ASC & STS

cetnamys19's picture

I request to run a backup on MS SQL sever, and i also have a backup on data\backup\ . Question, is the backup from c:\program files\symantec\symantec endpoint protection manager\data\backup\ is the same with MS SQL? will it over write the MS SQL DB of SEPM if i run the SEPM DB Restore?

Ajit Jha's picture

Dont get Confused. You are using a SQL or Embedded Database? Simple query.

Please answer it. Also answer How did u backed up you DB, either from Start\All Programs\SEPM\Database Backup and restore   or  From SQL Console ( Instance Backup)?

Regard's

Ajit Jha

Technical Consultant

ASC & STS

cetnamys19's picture

I'm using MS SQL. The backup was run by SEPM (the default backup configuration of SEPM and the db stored in data\backup\) Now my question is, is it OK that i will use the SEPM Database Backup and restore and use the db backup in data\backup\ although i'm using MS SQL?

Ajit Jha's picture

Yes, its perfectly alright. Use this link for your reference, http://www.symantec.com/business/support/index?pag...

Already mentioned both the ways and workaround for your concern in my previous comment.

Anyways tryout and let us know if you still have any concerns.

Regard's

Ajit Jha

Technical Consultant

ASC & STS

Rafeeq's picture

if you run the back from SEPM console. it will get stored in c:\program files\symantec\symantec endpoint protection manager\data\backup\

if your DB is in SQL you will have by name SEM5.db.

restrore the DB and then run the management server configuration wizard to sync.