Endpoint Protection

how move the sep sql database to new sql server

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

http://www.symantec.com/business/support/index?page=content&id=TECH104723&locale=en_US

Similar thread:

https://www-secure.symantec.com/connect/forums/sepm-sql-database-movement-one-disk-another-disk

you can perform a SQL backup of sem5 and restore to a new SQL

server or instant using the following SQL query

ALTER DATABSAE sem5 SET RECOVERY FULL

afterthat

copy the backup file to new sql server and restore the database as

sem5

note:
you must delelte user sem5 and then create new sem5 login

to delelte user sem5 :
open the sm5 database and choose security , users , locate and

delete the sem5 user

To create new sem5 user :
From the top of the hierarchly , open security , logins
Right Click Logins and choose New Login
Login Name : sem5
Enter password
On the left choose User Mapping and place a check next to sem5
In database role membership for : sem5 , place a check next to

dbowner(publice should already be check) and then click ok
Connect the SEPM to database by " repointing server to a new SQL

server