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

Article:TECH161849  |  Created: 2011-06-08  |  Updated: 2013-09-06  |  Article URL http://www.symantec.com/docs/TECH161849
Article Type
Technical Solution


Issue



When running the database maintenance on the BEWS it fails with error "Dump Database Failed.'


Error



ERROR : "Dump Database failed."

Maintenance has failed: 10, Dump database failed
 

Event viewer shows :-

Event Type: Error 
Event Source: Backup Exec 
Event Category: None 
Event ID: 57348 
User: N/A 
Description:-
 
Backup Exec Alert: Database Maintenance Failure 
(Server: "SERVER 01") (Job: "Database Maintenance") Summary of database maintenance activity: 
* Saved contents of BEDB database 
Maintenance has failed: 10, Dump database failed
 

SGMon debug log shows:-

 PersistentStore: CheckSqlExpressDBSizeLimit Edition:Standard Edition (64-bit) dbSizeMB=13
BESERVER: [09/06/11 12:42:00] [5508]     53 PersistentStore: Dumping database...
BESERVER: [09/06/11 12:42:00] [5508]     -1 Dump database BEDB
BESERVER: [09/06/11 12:42:00] [5508]     -1 Dump to File: C:\Program Files\Symantec\Backup Exec\Data\BEDB.bak
BESERVER: [09/06/11 12:42:00] [5508]     -1 Execute command: backup database BEDB to disk='C:\Program Files\Symantec\Backup Exec\Data\BEDB.bak' with format
BESERVER: [09/06/11 12:42:00] [5508]     -1 OpenFromInitializationString Connection String = Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=PWINHSEAU02;Locale Identifier=1033;Application Name=BEWS DBUTIL hr=0x0
BESERVER: [09/06/11 12:42:00] [5508]     -1 BACKUP DATABASE is terminating abnormally.
BESERVER: [09/06/11 12:42:00] [5508]     -1 Cannot open backup device 'C:\Program Files\Symantec\Backup Exec\Data\BEDB.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
BESERVER: [09/06/11 12:42:00] [5508]     -1 Execute command failed: 0x80040e14
BESERVER: [09/06/11 12:42:00] [5508]     -1 OS ERROR: 0x80040e14 (-2147217900)
BESERVER: [09/06/11 12:42:00] [5508]     -1 Deinitialize...
BESERVER: [09/06/11 12:42:00] [5508]     17 Alert Database Maintenance Failure, Notify: No, EventLog: Yes, Trap: No
BESERVER: [09/06/11 12:42:00] [5508]     53 PersistentStore: Maintenance operations completed
BESERVER: [09/06/11 12:42:00] [5508]     -1 Error(53/65): 10:Dump database failed


 


Environment



Backup Exec Database (BEDB) is  hosted on the full instance of the SQL (eg. SQL 2008 Full Edition) the database maintenance fails with the above error . 

 


Cause



The account used by the SQL instance service SQL SERVER (INSTANCENAME) is domain admin or local admin and it does not have the permissions on the Data folder "X:\Program Files\symantec\Backup Exec\Data"

 


Solution



To resolve this issue:-

1. Grant full permissions to the account used by the SQL instance service SQL SERVER (INSTANCENAME) on the Data directory   "X:\Program Files\symantec\Backup Exec\Data" and run the database maintenance.

 


Supplemental Materials

SourceEvent ID
Value57348
Description
Backup Exec Alert: Database Maintenance Failure 
(Server: "SERVER 01") (Job: "Database Maintenance") Summary of database maintenance activity: 
* Saved contents of BEDB database 
Maintenance has failed: 10, Dump database failed
 


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


Terms of use for this information are found in Legal Notices