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

Article:TECH67239  |  Created: 2010-01-18  |  Updated: 2014-07-10  |  Article URL http://www.symantec.com/docs/TECH67239
Article Type
Technical Solution

Product(s)

Issue



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\Symantec\Backup Exec\ directory (default location), and double-click on BEUtility to run it (Figure 1).
Figure 1

  
 
3. A 'Yes / No' dialog box will show (Figure 2). Click on the Yes button on the dialog box.
Figure 2
 
 
 
4. Expand Known Computers, right-click on All Media Servers, select New Media Server, enter the name of the media server, and click OK.
5. In the left window pane, select the Backup Exec media server name, and then click Repair Database from the Database Tasks options in the left window pane (Figure 3).
 
Figure 3
 
 
6. The Operation Progress dialog box will appear, indicating the process of repairing the database (Figure 4).
Figure 4
 

 
7. On completion, click Close
8. Again, in the left window pane, select the Backup Exec media server name, and then click Rebuild Indices from the Database Tasks options in the left window pane (Figure 5).
Figure 5
 
 
 
9. The Operation Progress dialog box will appear, indicating the process of rebuilding the database indices (Figure 6).
Figure 6
 
 
 
10. On completion, click Close.  
11. In the left window pane, select the Backup Exec media server name, and then click Compact Database from the Database Tasks options in the left  window pane (Figure 7).
Figure 7
 
 
 
12. The Operation Progress dialog box will appear (Figure 8), indicating the process of compacting the database.
Figure 8
 
 
 
13. On completion, click Close.  
14. In the left window pane, select the Backup Exec media server name, and then click Age Database from the Database Tasks options in the left window pane (Figure 9).
Caution! Failure to adjust your Database Maintenance setting may result in the loss of historical data.  
Figure 9
 
 
 
15. The Operation Progress dialog box will appear, indicating the process of aging the database (Figure 10).
Figure 10
 
 
 
16. On completion, click Close
 
17. In the left window pane, select Backup Exec media server, and then click Check Database Consistency from the Database Tasks options in the left window pane (Figure 11).
 
Figure 11
 
 
 
18. The Operation Progress dialog box will appear, indicating the process of checking the database consistency (Figure 12).
Figure 12
 
  
 
19. On completion, click Close.  
20. Select the File | Exit menu option to quit BEUtility.
21. Run additional tests in Backup Exec to confirm the application is functioning properly.



Legacy ID



318243


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


Terms of use for this information are found in Legal Notices