Best Practice guide for moving Endpoint Protection Manager SQL Server database from an existing SQL Server database to a new SQL Server database

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 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.