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:
- Microsoft SQL Server
This topic describes how to back up these databases.
Backing up the PostgreSQL database
- Connect to the database server using pgAdmin.
- Log on to database server with a user that has the privileges to back up the database.
- Right-click the database that you want to back up, and select Backup.
The Backup database dialog box appears.
- In Filename, specify the location where you want to store the backed up files.
- From Format, select Tar.
- Click Backup to start the backup process.
Backing up the SQL Server database
- Connect to database server with SQL Server Management Studio using the sa account.
- Right-click the database that you want to back up and select Tasks > Back Up.
The Back Up Database dialog box appears.
- Ensure that Back up type is set to Full.
- In Destination, specify the location where you want to store the backed up files.
- Click OK to start the backup process.
Backing up the Oracle database
- Run the exp command from the command prompt or shell.
- Log on to the database server with an account that has privileges to back up the database.
- Press Enter.
- Enter the array fetch buffer size if you want to modify the default value, and press Enter.
- Specify the location where you want to store the backed up files, and press Enter.
- Type 1 to indicate that you want to back up the entire database, and press Enter.
- Press Enter when prompted for the following options:
- Export grants (yes/no): yes >
- Compress extents (yes/no): yes >
- Export table data (yes/no): yes >
- 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
Was this page helpful? Yes No Submitting... Thank you