Disaster recovery best practices for Data Center Security Server Advanced (SDCS-SA)

Products

• Data Center Security Server Advanced

Issue/Introduction

Disaster recovery best practices for Data Center Security Server Advanced

Environment

Data Center Security Server Advanced 

Cause

Database recovery from a backup for Symantec Data Center Security Server: Server Advanced (SDCSSA)

Resolution

Steps to restore the DCS database from a backup :

1) Install a new SQL Database server.

2) Stop "Symantec Data Center Security Server Manager" service.

3) Login to SQL Server Management Studio.

4) Browse Databases, and right-click on SCSPDB database
 
5) Click on Tasks > Restore > Select the Backup and run it.

6) Browse Databases, and right-click on DCSC_UMC database.

7) Click on Tasks > Restore > Select the Backup and run it.

8) Additionally, you may import or create database accounts/passwords from SQL Server database (https://docs.microsoft.com/en-us/troubleshoot/sql/security/transfer-logins-passwords-between-instances).

9) Start "Symantec Data Center Security Server Manager" service.

 

Additional Information

References :

https://knowledge.broadcom.com/external/article/162273/disaster-recovery-procedure-for-symantec.html

https://support.microsoft.com/en-us/help/246133/how-to-transfer-logins-and-passwords-between-instances-of-sql-server

https://knowledge.broadcom.com/external/article?legacyId=HOWTO119461