Restoring the External Data Mart server

Last Updated : Feb 11, 2023 |

About this task

Context Store External Data Mart (EDM) is an external component of Avaya Oceana®.

Use this procedure to restore the Context Store External Data Mart (EDM) server before switching back from Data Center 2 to Data Center 1.

When you restore to Data Center 1, copy the EDM contents from Data Center 2 to the EDM in Data Center 1. Ensure that you backup and restore the database to complete the restoring of Context Store EDM.

Before you begin

  • On Data Center 1 and Data Center 2, set the Cluster State of Avaya Oceana® Cluster 1 to Deny New Service. For instructions about how to change the cluster state, see Deploying Avaya Oceana®.

  • Configure the Disaster Recovery Mode attribute in the OceanaConfiguration service in System Manager.

Procedure

  1. Log in to the primary SQL Server hosting the EDM database in Data Center 2.

    You must log in with the SQL Server domain user credentials with administrative right to all SQL Server(s) hosting the EDM on DC2.

  2. Open SQL Server Management Studio.
  3. In the Object Explorer pane, click Connect > Database Engine.

    SQL Server Management Studio displays the Connect to Server dialog box.

  4. In the Server name field, select the local instance of SQL Server.
  5. In the Authentication field, select SQL Server Authentication.
  6. In the Login and Password fields, enter the system administrator credentials.

    The system administrator is usually the default sa user created during SQL Server installation.

  7. Click Connect.
  8. In the Object Explorer pane, click Databases > <EDM Database>.
  9. Right-click the EDM database and click Tasks > Back Up.

    SQL Server Management Studio displays the Back Up Database dialog box.

  10. In the navigation pane, click General.
  11. In the Backup type field, select Full.
  12. In the Destination area, click Add.
  13. In the Select Backup Destination dialog box, select the backup folder location, specify the backup file name with the .bak extension, and click OK.

    Ensure that the SQLService User login (services.msc) has full permissions on the backup folder.

  14. To provide full permissions to the SQLService User login, do the following:
    1. Go to the backup folder location.
    2. Right-click the backup folder and click Properties.
    3. On the Security tab, select the SQLService User login and click Edit.
    4. In the Permissions area, select the Full control check box.
    5. Click OK.
  15. In the navigation pane, click Media Options.
  16. In the Overwrite media area, select Overwrite all existing backup sets.
  17. In the Reliability area, select the Verify backup when finished check box.
  18. In the navigation pane, click Backup Options.
  19. In the Description field, type a description for the backup.
  20. In the Set backup compression field, select Compress backup.
  21. Click OK.
  22. Log in to the primary SQL Server hosting the EDM database in Data Center 1.

    You must log in with the SQL Server domain user credentials with administrative right to all SQL Server(s) hosting the EDM on DC1.

  23. Open SQL Server Management Studio.
  24. In the Object Explorer pane, click Connect > Database Engine.

    SQL Server Management Studio displays the Connect to Server dialog box.

  25. In the Server name field, select the local instance of SQL Server.
  26. In the Authentication field, select SQL Server Authentication.
  27. In the Login and Password fields, enter the credentials of the system administrator.

    The system administrator is usually the default sa user created during SQL Server installation.

  28. Click Connect.
  29. In the Object Explorer pane, click Databases > <EDM Database>.
  30. Right-click the EDM database and click Tasks > Restore > Database.

    SQL Server Management Studio displays the Restore Database dialog box.

  31. In the navigation pane, click General.
  32. In the Device field, browse and select the backup file location that you create in Data Center 2.
  33. In the navigation pane, click Options.
  34. In the Restore options area, select the Overwrite the existing databases (WITH REPLACE) check box.
  35. In the Server Connections area, select the Close existing connections to destination database check box.
  36. Click OK.
  37. In the Object Explorer pane, right-click the master database and click New Query.
  38. In the content pane, run the following command to re-enable the optional non-system administrator user on the primary SQL Server in Data Center 1: 
    USE <database_name>;
GO
sp_change_users_login @Action='update_one', @UserNamePattern='<database_user>', 
   @LoginName='<login_name>';
GO

    For example:

    USE CSEDM;
GO
sp_change_users_login @Action='update_one', @UserNamePattern='csEDMLogin',
@LoginName='csEDMLogin';
GO