Endpoint Protection

Hi team,

We need to move the SQL database from one drive to another drive in SEPM server. (Less space in current drive)

Please let us know what the steps or details required to move the database to another drive.

SEPM and SQL server are installed in the same server.

We have the following configurations.

SEPM server with 12.1 RU1 MP1

SQL Server 2005 ENT SP3

Only windows authentication mode is enabled. SA account is disabled. What are users accounts required to do this activity?

Please help me on this.

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/business/support/index?page=content&id=TECH106213&locale=en_US

https://www-secure.symantec.com/connect/forums/moving-sepm-embedded-database

https://www-secure.symantec.com/connect/forums/how-move-sepm-sql-2005-one-drive-another-drive

Hi Prachand,

Did we need to re configure the SEPM after moving the Database to another drive?

also did we need to move tempdb also? as mention above, we have disabled the SA account, is thre any impact while moving toanother drive, we have enabled only windows authentication.

yes

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/business/support/index?page=content&id=TECH106213

Disaster Recovery steps performed on the SEPM. http://www.symantec.com/docs/TECH160736

Did we need to re configure the SEPM after moving the Database to another drive?

As I see it, it's not even necessary to run the Configuration Wizard after the moving of the database. There are no data that changed from the SEPM's point of view (e.g., SQL Server host name or login or database user).

did we need to move tempdb also?

No.

As Ashish says, be sure to have the Disaster Recovery data at hand.

Did we need to re configure the SEPM after moving the Database to another drive? No not needed.

did we need to move tempdb also? No

hi,

any update on this ?

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

after that

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