How to recover the Backup Exec Database from the BEDB backup file

Issue

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

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.

Backing up or Dumping the BEDB database:

To dump a Backup Exec database You can use the Backup Exec Utility program (..\Program Files\Symantec\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.

2 In the task pane, select Database Tasks->Dump Database.

3 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\Symantec\Backup Exec\data folder as shown in the fig.

Incase 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.

Restoring the BEDB database:

Backup Exec Utility program (..\Program Files\Symantec\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.

2 In the task pane, select Database Tasks->Recover Database.

3.Use the option to “Drop the existing database and reload from backup”.

4.After the operation finishes, click Close on the Operation Progress screen and launch Backup Exec program.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s