How to run an extensive database repair and cleanup of the Backup Exec database when it is found to be inconsistent

How to run an extensive database repair and cleanup of the Backup Exec database when it is found to be inconsistent

  • Article ID:100020074
  • Last Published:
  • Product(s):Backup Exec
  • Ratings: 5 1

Problem

How to run an extensive database repair and cleanup of the Backup Exec database when it is found to be inconsistent.

Solution

To run an extensive repair and cleanup of the Microsoft SQL Express database that Backup Exec uses, perform the following steps:
 
1. Make sure no Backup / Restore jobs or Live Update sessions are running in Backup Exec and close the user interface.
 
2. Go to the C:\Program Files\Veritas\Backup Exec\ directory ( default location), and double-click on BEUtility.exe to run it.

3. A ' Yes / No' dialog box will show. Click on the Yes button on the dialog box.
 
 
4. Expand Known Computers and Backup Exec server name will be listed in Right-hand pane when clicked on All Backup Exec servers. If it is not present then, right-click on All Backup Exec Servers, select New Backup Exec Server, enter the name of the Backup Exec server, and click OK.
 
5. In the left window pane, select the Backup Exec server name and then click Repair Database from the Database Tasks options in the left window pane OR right-click on the Backup Exec server name and then click Repair Database.
 
 
6. You may get a pop up message similar to below that Remote Registry service will be started and then stopped, click Yes to continue.
 
 
7. Select OK on Repair Database window.
 
 
8. Click Yes in the Do you want to continue? message as below.
 
 
9. The Operation Progress dialog box will appear, indicating the process of repairing the database ( Figure 4).
 

10. On completion, click Close
 
11. Repeat the steps from Step 5 above and this time click Rebuild Database Indices from the Database Tasks options.
 
12. The Operation Progress dialog box will appear, indicating the process of rebuilding the database indices.
 
 
13. On completion, click Close.
 
14. Repeat the steps from Step 5 above and this time click Compact Database from the Database Tasks options.
 
15. The Operation Progress dialog box will appear, indicating the process of compacting the database.
 
 
16. On completion, click Close.  
 
17. Repeat the steps from Step 5 above and this time click Age Database from the Database Tasks options.
 
18. The Operation Progress dialog box will appear, indicating the process of aging the database.

 
19. On completion, click Close
 
20. Repeat the steps from Step 5 above and this time click Check Database Consistency from the Database Tasks options.
 
21. The Operation Progress dialog box will appear, indicating the process of checking the database consistency.
 
 
 
22. On completion, click Close.  
 
23. Select the File | Exit menu option to quit BEUtility.
 
24. Run additional tests in Backup Exec to confirm the application is functioning properly.
 

Related Articles

How to change the Backup Exec Database (BEDB) location using BEUTILITY.

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

How to resynchronize the Backup Exec for Windows Servers System Logon/Service Account (BESA) and installation to potentially resolve functional issues with the application

Was this content helpful?