How to move a Symantec Endpoint Protection Manager (SEPM) SQL database to a new SQL server by backing-up and restoring the database.
Perform a SQL backup of the database and restore it to a new SQL server or instance using the following procedure:
Once the database is restored to the new SQL server or instance, the sem5 and reporter database users must be deleted and a new sem5 login must be created. This process is because there is no sem5 login and a login for a database can't be created if that database user already exists.
Note: These instructions assume that the default naming conventions are in use. If the previous instance was not named sem5 the database user names are different. The reporting user appears similar to 'REPORTER_databasename'.
At this stage you either installed a new SEPM, or plan to use the same SEPM as before. In either case, the SEPM needs to be pointed to the new database location.
Run the Management Server Configuration Wizard to point the SEPM to the new database.