Best Practices guide to moving the Symantec Endpoint Protection Manager SQL Server database from an existing SQL Server database to a new SQL Server database

book

Article ID: 154872

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

How can I move the Symantec Endpoint Protection Manager SQL Server database from an existing SQL Server database to a new SQL Server database?

Resolution

In order to move the Symantec Endpoint Protection Manager SQL Database (DB), please follow the steps as outlined below.

 

  1. Detach the Database in question from the Existing Database in SQL 2000 via the "SQL 2000 Enterprise Manager."
    Note: If using SQL 2005, the "SQL Server Management Studio".
  2. After the Database is detached, navigate to the appropriate data folder where the existing SQL server data files are stored.

    Example:
    C:\Program Files\Microsoft SQL Server\MSSQL\xxxx\DATA

    OR


    C:\Program Files\Microsoft SQL Server\MSSQL\DATA.
     
  3. Copy the following database files to the data folder for the new server housing the new SQL DB
    • <db_name.MDF>
    • <db_name.NDF>
    • <db_name.LDF>

  4. On the server where you want to move the existing SQL DB to, Right click on the Database instance, and click on Tasks>All Tasks> Attach Database.
  5. Type the path to the <db_name.MDF> file, and the wizard will automatically pick up the other files. (.NDF and .LDF)
  6. Click OK. The wizard will automatically collate and attach the Symantec Endpoint Protection Manager console database to the new SQL Database.
  7. Create a new sem5 account in your new SQL server with "default database" of sem5, and "default language" of English
  8. Add user sem5 to system login, for example, the original database name is sem5, the username is sem5, you need to add user sem5 to system login and set the new password, and run "exec sp_change_users_login 'AUTO_FIX','sem5'" 
  9. Once complete, Run the "Management Server Configuration Wizard" and point the Symantec Endpoint Protection Manager to the new server housing the newly attached Database.
    • In the Database Server name tab, type in the <HostName> of the new server, fill in the remaining required details and complete the configuration wizard.