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

Article:TECH104723  |  Created: 2008-01-15  |  Updated: 2012-04-10  |  Article URL http://www.symantec.com/docs/TECH104723
Article Type
Technical Solution


Environment

Issue



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

 


Solution



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 would automatically collate and attach the Symantec Endpoint Protection Manager console database to the new SQL Database.
     
  7. 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> /<ComputerName> of the new server, fill in the remaining required details and complete the configuration wizard.
       
  8. Once the wizard has completed its task, log into the Symantec Endpoint Protection Manager Console and the configured Policies and Clients will appear as in the previous installation.

    References
    Best Practices guide for moving the Symantec Endpoint Protection Manager SQL Server database from one drive to another on the same machine:
    http://www.symantec.com/docs/TECH106213



 



Legacy ID



2008041601053448


Article URL http://www.symantec.com/docs/TECH104723


Terms of use for this information are found in Legal Notices