How perform a manual Backup and Restore of Backup Exec database(BEDB)

How perform a manual Backup and Restore of Backup Exec database(BEDB)

Article: 100022630
Last Published: 2020-04-01
Ratings: 2 4
Product(s): Backup Exec

Problem

How to perform a manual Backup and Restore of Backup Exec database (BEDB).

Solution

Backup Exec automatically sets up a daily backup (dump) of the BEDB as a part of Database Maintenance,But there are times when it is required to back up the BEDB manually.

For example, It is required to backup the BEDB prior upgrading Backup Exec or before performing maintenance on the media server.

Dump Database function is used to backup the BEDB to the hard drive. After dumping the database , It is possible to recover the media server from a failure.

Note:
Dumping a database is another term for backing up a database.
 
 
 
NOTE : Please ensure that DLM is disabled before performing any of the following steps to prevent automatic deletion of backup sets using steps mentioned in following technote :
 
 
 

Backing up or Dumping the BEDB database:

To dump a Backup Exec database You can use the Backup Exec Utility program (..\Program Files\Veritas\Backup Exec\BEUtility.exe) and perform the following steps within the Backup Exec Utility interface:
  1. Select a media server from either a media server group or from the All Media Servers subnode.
  1. In the task pane, select Database Tasks->Dump Database. Or right click on the Server name in the Right Pane and choose Dump database.
  1. After the operation finishes, click Close on the Operation Progress screen.
This operation backs up the BEDB database to a flat file "BEDB.bak" at "..\Program Files\Veritas\Backup Exec\data folder as shown in the fig.

In case the BEDB is hosted on remote SQL server, this file is created at " ..\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data on the remote server.

 

 
 
 
 
NOTE : Please ensure that DLM is disabled before performing any of the following steps to prevent automatic deletion of backup sets using steps mentioned in following technote :
 
 

Restoring the BEDB database:

Backup Exec Utility program (..\Program Files\Veritas\Backup Exec\BEUtility.exe) can be used to recover the BEDB manually.
  1. Select a media server from either a media server group or from the All Media Servers subnode.
  1. In the task pane, select Database Tasks->Recover Database. Or right click on the Server name on right pane and click on Recover Database. 
  1. Use the option to "Drop the existing database and reload from backup".
  
  1. After the operation finishes, click Close on the Operation Progress screen and launch Backup Exec program.
 

Was this content helpful?