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)
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
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)
4. In the Recover Database dialog box, select Drop existing database and reload from base (Figure 2)
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.
8. Click Next to continue with creating new accounts (Figure 4)
9. Select Add a new logon account, and click Next (Figure 5)
10. Type the Backup Exec service account name and password, and then click Next (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.