Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Move SQL server to a New server

Created: 20 Sep 2012 • Updated: 20 Sep 2012 | 2 comments
This issue has been solved. See solution.

how move the sep sql database to new sql server

Comments 2 CommentsJump to latest comment

Brɨan's picture

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

Similar thread:

https://www-secure.symantec.com/connect/forums/sep...

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

SAMI ALAMMARI's picture

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
 

BALFAKIH COMPUTERS
 
SOLUTION