Backing up the databases

BMC Decision Support – Network Automation databases include ETL work repository, ETL master repository, and the data warehouse. Following types of databases are supported:

  • PostgreSQL
  • Microsoft SQL Server
  • Oracle

This topic describes how to back up these databases.

Backing up the PostgreSQL database

  1. Connect to the database server using pgAdmin.
  2. Log on to database server with a user that has the privileges to back up the database.
  3. Right-click the database that you want to back up, and select Backup.
    The Backup database dialog box appears.
     
  4. In Filename, specify the location where you want to store the backed up files.
  5. From Format, select Tar.
  6. Click Backup to start the backup process.

Backing up the SQL Server database

  1. Connect to database server with SQL Server Management Studio using the sa account.
  2. Right-click the database that you want to back up and select Tasks > Back Up.
    The Back Up Database dialog box appears. 
  3. Ensure that Back up type is set to Full
  4. In Destination, specify the location where you want to store the backed up files.
  5. Click OK to start the backup process.

Backing up the Oracle database

  1. Run the exp command from the command prompt or shell.
  2. Log on to the database server with an account that has privileges to back up the database.
  3. Press Enter.
  4. Enter the array fetch buffer size if you want to modify the default value, and press Enter.
  5. Specify the location where you want to store the backed up files, and press Enter.
  6. Type 1 to indicate that you want to back up the entire database, and press Enter.
  7. Press Enter when prompted for the following options:
    1. Export grants (yes/no): yes >
    2. Compress extents (yes/no): yes >
    3. Export table data (yes/no): yes >
  8. Note down the following settings:
    • Name of the database
    • User name that owns this database
    • Password of that user
    • Oracle database version
    • Character set in which the dump is exported
    You need this information while restoring the database.
Was this page helpful? Yes No Submitting... Thank you

Comments