Backup Exec for Windows Servers (BEWS) SQL Express Database Maintenance fails with Error "Dump Database failed."

Article:TECH142663  |  Created: 2010-10-26  |  Updated: 2012-04-27  |  Article URL http://www.symantec.com/docs/TECH142663
Article Type
Technical Solution

Product(s)

Issue



Backup Exec for Windows Servers (BEWS) SQL Express Database Maintenance fails with Error "Dump Database failed."


Error



Summary of Database maintenance activity

saved contents of BEDB database

maintenance has failed : 10, Dump Database failed


Solution



Solution 1:
NOTE: It is always important to obtain a backup copy before making changes to the Backup Exec database. Stop the "SQL SERVER (BKUPEXEC)" service, copy X:\Program Files\Symantec\Backup Exec\Data to a separate location prior to completing the steps below. Restart the SQL SERVER (BKUPEXEC)" service and all dependencies

(1) Run a Database Consistency Check using BEUtility to check if the BEDB database or the BE_DLO database is failing with database consistency errors.  Please refer the following document for more information::
 

How to check the Backup Exec database for consistency when a Backup Exec service pack will not install, or a repair will not complete successfully
(2) If the Backup Exec database fails on the consistency check, run an extensive repair of the Backup Exec Database (BEDB and/or BE_DLO). Please refer the following document for the same:
 
How to run a extensive database repair and cleanup of the Backup Exec database when it is found to be inconsistent 
(3) If the extensive repair fails on the BEDB database or the BE_DLO database, launch BEUTILITY and perform a 'Recover Database' and 'Reload from Backup' on the corresponding database and again run a consistency check using BEUtility. If the consistency check completes successfully, run the "Dump database" command.

NOTE: It is not recommended to recover the database from base without opening a support case with Symantec to determine if this is the best course of action, because this will put a blank database in place.  If the consistency check, repair, or backup (dump) of the database continues to fail with the same error, download/install the SQL Management Studio.Express Tools, and attempt to run backup with this Native SQL Backup Utility.
 
Microsoft SQL Server Management Studio Express
 http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
If the backups or other SQL Maintenance operations still fail with the SQL Native Backup Utility, check the Windows Application Event Viewer Logs for SQL errors and warnings that may help further diagnose the failure.  
 
Solution 2:
Confirm that the Backup Exec database or the Backup Exec dlo database are not set as compressed databases. 
  1. Go to the destination folder where Backup Exec databases reside. For default it will be in:  C:\Program Files\Symantec\Backup Exec\Data
  2. Confirm first that the root directory 'C' or 'D' (where ever Backup Exec is installed) is not set to be compressed. Right click on the drive itself and select properties. On the 'General' tab confirm that the "compress drive to save disk space" is not selected.
  3. Confirm that the folders that contain the data files are not set for compression. Right click on the folder itself and select properties.On the 'General' tab select the button for 'Advanced" on the lower right side. Confirm that the "compress drive to save disk space" is not selected.
  4. Confirm that the database files themselves are not set for compression. Right click on the database file itself and select properties. (Do this for the both database file and the log file for each of the databases: bedb_data.mdf and bedb_log.ldf and the be_dlo.mdf and the be_dlo_log.ldf) On the 'General' tab select the button for 'Advanced" on the lower right side.Confirm that the "compress drive to save disk space" is not selected
  5. Start all services for Backup Exec to confirm that they start on the machine. 
Solution 3:
Uninstall and Reinstall Desktop and Laptop Option 
 
Step 1
  1. Click on tools >Install Options and License Keys on this Media Server>
  2. Click Next
  3. Uncheck the Desktop and Laptop Option
  4. Click Next
  5. Click Install
  6. Complete the installation
  7. Finish 
Step 2
Follow the same procedure in Step 1 
Check  the Desktop and Laptop Option
Complete the Installation

Solution 4 :

Run a Repair install of Backup Exec from Add\Remove programs.

How to run a repair installation for Backup Exec for Windows Servers 10d and later http://www.symantec.com/docs/TECH23481  





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


Terms of use for this information are found in Legal Notices