How to create a new SQL Database in Backup Exec for Windows Servers for testing purposes or when the original database is corrupt and cannot be repaired (BEDB drop and reload from base)

Article:TECH23769  |  Created: 2010-01-02  |  Updated: 2014-05-12  |  Article URL http://www.symantec.com/docs/TECH23769
Article Type
Technical Solution

Product(s)

Issue



How to create a new SQL Database in Backup Exec for Windows Servers for testing purposes or when the original database is corrupt and cannot be repaired (BEDB drop and reload from base)


Solution



Please note:  The backup copy of the Backup Exec Database (BEDB.Bak located in the \Program Files\Symantec\Backup Exec\Data or \Program Files\VERITAS\Backup Exec\NT\Data Folder) should be copied to an alternate location prior to performing the procedure below.  If the issue is not resolved by replacing the database with a fresh copy, the previous database can be reloaded (See rolling back changes on the Backup Exec Database in the Related Documents below).  Be aware also that all the media (tape or backup-to-disk) will be presented to Backup Exec as Imported Media and could potentially be overwritten by a new backup job which runs after the database has been replaced with the fresh copy.  Consider moving all the media into a Media Set which has some level of Overwrite Protection assigned to it and then only move the media which can be overwritten to the Scratch Media Set afterward prior to creating new backup jobs.  

To create a new SQL database, perform the following steps:

1. Launch BEUtility (double click on BEUtility.exe).
  • For Backup Exec 9.x and Backup Exec 10.x, go to the <Drive Name>:\Program Files\VERITAS\Backup Exec\NT directory (default location)
  • For Backup Exec 11.x and above the default data directory is <Drive Name>:\Program Files\Symantec\Backup Exec\Data
2. Expand Known Media Servers, right-click All Media Servers, select New Media Server, enter the name of the media server, and click OK

3. In the right pane, select the Backup Exec media server, and then click Recover Database from the Database Tasks options in the left pane (Figure 1)
 
Figure 1
 

4. In the Recover Database dialog box, select Drop existing database and reload from base (Figure 2)
 
Figure 2
 
 
The Operation Progress dialog box will appear indicating the process of recovery the database (Figure 3).
 
Figure 3
 

5. On completion, click Close. Select the File | Exit menu option to quit BEUtility.

6. Confirm and document which account is running the Backup Exec Services in the Windows Services Applet (except for the Remote Agent which runs under the Local System Account).

7. Launch the Backup Exec Interface.
 
Note: Since the SQL database is new, Backup Exec logon accounts will have to be recreated.

8. Click Next to continue with creating new accounts (Figure 4)
 
Figure 4
 

9. Select Add a new logon account, and click Next (Figure 5)
 
Figure 5
 

10. Type the Backup Exec service account name and password, and then click Next (Figure 6)
 
Figure 6
 

11. Continue with the Logon Account Wizard to configure the Backup Exec options

Note: All media sets, backup-to-disk folders, and other settings will have to be created or configured again.  In Backup Exec 11.x and above, run LiveUpdate (Tools>LiveUpdate) also to confirm all the latest patches have been applied.



Legacy ID



254014


Article URL http://www.symantec.com/docs/TECH23769


Terms of use for this information are found in Legal Notices