Creating the External Data Mart database for the standalone deployment

Last Updated : Apr 04, 2022 |

About this task

Use this procedure to create the External Data Mart (EDM) database for the standalone deployment EDM.

Procedure

  1. Log in to the primary EDM SQL Server.
  2. Open the SQL Server Management Studio on the SQL Server that needs to become the primary replica.
  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, expand Databases.
    Important:

    Do not point your Avaya Oceana® to the new EDM until EDM configuration and migration is complete. EDM configuration and migration also include creating an optional non-sa user and adding the EDM into the Basic Availability Group (BAG).

  9. Right-click Databases and click New Database.

    SQL Server Management Studio displays the New Database dialog box.

  10. In the navigation pane, click General.
  11. In the Database name field, enter a name for the EDM database.
  12. In the Database files section, do the following:
    1. For File Type = ROWS Data, click the three dots to the right of the Path field.
    2. Browse to the correct folder and click OK.

    To change the initial size for the EDM Data file, click the arrows to the right of the Initial Size (MB) value for File Type = ROWS Data and change the default value. For example, for 300 GB, enter 307200.

  13. In the Database files field, do the following:
    1. For File Type = LOG, click the three dots to the right of the Path field.
    2. Browse to the correct folder and click OK.

    To change the initial size for the EDM Log file, click the arrows to the right of the Initial Size (MB) value for File Type = LOG and change the default value. For example, for 20 GB, enter 20480.

    Ensure that hourly transaction log backups are taken. You can download the SampleSQLServerAgentScripts.zip from https://support.avaya.com/ or https://www.devconnectprogram.com/. For more information on configuring the SampleSQLServerAgentScripts, see the Configuring automated SQL Server Agent jobs topic in the Deploying Avaya Oceana® document.

    You must also create the same paths and folders for EDM data files and EDM log files on the secondary SQL replica before adding the EDM to BAG.

  14. In the navigation pane, click Options.
  15. In the Collation field, select the appropriate option or leave it as default.
  16. In the Recovery model field, select Full.
  17. Click OK.