Endpoint Protection

 View Only

  • 1.  Move from MSSQL 2005 database back to embedded?

    Posted Jun 15, 2010 07:03 AM
    Hallo,
    is this possible on SEP 11.0.6005.562?

    Is there a how-to in your knowledge base?
    I know I have to do a disaster recovery before to save all essentials files (I did a move from embedded to SQL two years ago).

    Thank you.


  • 2.  RE: Move from MSSQL 2005 database back to embedded?

    Posted Jun 15, 2010 07:48 AM
    it might be possible , however no such documents from symantec


  • 3.  RE: Move from MSSQL 2005 database back to embedded?

    Posted Jun 15, 2010 08:02 AM

    Below are the steps for the same(Remove SEPM from replication if configured)

    1. Backup the SEPM server certificate
    2. Backup the SQL database (Use Database Back Up and Restore" feature from the Start Menu)
    3. Uninstall the Symantec Endpoint Protection Manager along with the Database
    4. Reinstall the Symantec Endpoint Protection Manager configured to use a Embedded Database
    5. Restore the SEPM server certificate
    6. Restore the backup copy of the database (Use Database Back Up and Restore" feature from the Start Menu)
    7. Reconfigure the Symantec Endpoint Protection Manager database to recognize Embedded Database (Run "Management Server Configuration Wizard" from the Start Menu)
    8. The SEPM service will be restarted at the end of this process, and you may log into the SEPM console.

    Disaster recovery article will be helpful for the above steps

    Title: 'Best Practices for Disaster Recovery with the Symantec Endpoint Protection Manager'
    Web URL: http://service1.symantec.com/support/ent-security.nsf/docid/2007082112135948?Open&seg=ent


  • 4.  RE: Move from MSSQL 2005 database back to embedded?

    Posted Jun 15, 2010 08:21 AM
    Please follow the steps for Moving from the Microsoft SQL Server to Sybase Embedded Database involves the following steps:
     
    1.Take the Backup the SEPM server certificate
     
    2.Take the Backup of the SEPM database using Back up and Restore  wizard
     
    3.Uninstall the Symantec Endpoint Protection Manager
     
    Use the "Change" installation option in Add/Remove Programs.
     
    Warning:You must uninstall the Symantec Endpoint Protection Manager with the "Change" installation option or the upgrade will fail.
     
    4.Reinstall the Symantec Endpoint Protection Manager configured to use an embedded database 
     
    5.Restore the SEPM server certificate
     
    6.Restore the backup copy of the database
     
    7. Run the Managements server configuration wizard to Reconfigure the Symantec Endpoint Protection Manager database to recognize the embedded database
    Click Finish.
     
    8. Restart the SEPM service.


  • 5.  RE: Move from MSSQL 2005 database back to embedded?

    Posted Aug 24, 2020 01:20 PM
    Is it necessary to check "Remove the Database during uninstall"  ??

    ------------------------------
    State of Utah
    ------------------------------

    Original Message


  • 6.  RE: Move from MSSQL 2005 database back to embedded?

    Broadcom Employee
    Posted Aug 24, 2020 01:22 PM
    No. You can just delete the db from SQL Management Studio if you need it removed.

    ------------------------------
    John Owens
    Principal Product Support
    Symantec
    United States
    ------------------------------

    Original Message


  • 7.  RE: Move from MSSQL 2005 database back to embedded?

    Posted Jun 15, 2010 08:34 AM
    Yes , it is possible

    Already done this 2 years ago in MR2.MP1 when we doing the POC.


    Regards...
    Ramji Iyyer


  • 8.  RE: Move from MSSQL 2005 database back to embedded?
    Best Answer

    Posted Jun 15, 2010 08:38 AM

    Hi,
    thank you all for your help.