06-02-2011 01:51 AM
Sush,
I have performed the SQL downgrade on our Symantec Backup Exec Server and all looks to be successfull especially since after I moved the Backup Exec DB from SQL 2K5 Standard Edition to SQL 2K5 Express Edition. I run a number of test backup jobs against one of our Tape library partitions and all went well. This morning, I received an error from Backup Exec Services indicating Database Consistency issue with the message below:
Summary of database maintenance activity:
* Performed database consistency check for BEDB database
Maintenance has failed: 10, Dump database failed
I have manually run the Database consistency check against our backup Exec server and it completed successfully this morning. Can you advice on what else I should do to troubleshoot this error on my server?
Drewdarko
06-02-2011 02:31 AM
If you see the error "Dump database failed" did you tried dumping the databse manually? You can try this using BEUtility .Right click server name and select dump database
06-02-2011 11:27 AM
I selected the server and Dump the database. The message I received is :
Starting database utility operation.
Dumping the contents of BEDB database to disk.
Error: Database dump to disk failed.
Database utility for server SERVERNAME ended with errors.
Please advice ASAP on what to do next.
Thanks
06-02-2011 11:59 PM
What version of Backup Exec are you running , are there two instances of the database in BE_DLO and BEDB ? If yes is the dump database failing on BE_Dlo database.
What is the size of the database ? i.e MDf and ldf files
The limit for database size is 4 Gb .
Check the SQL server(BACKUPEXEC) Service is running on some other account .Try switching to Local system acount and see if that helps .
Try running a repair Database using beutility
06-07-2011 12:40 PM
Our Backup Exec Version is 11.0 Rev 7170. The old MSSQL instance already exists on this server and I installed the new instance SQLEXPRESS on the same server so Yes 2 instances exist.
For the SQL 2005 Express instance (SQLExpress) there are 2 DBs (System Databases and BEDB) and on the original DB instance (MSSQLSERVER) there are 4 Databases (System Databases, Database Snapshots, config and datamine).
The dump db error is failing on BEDB
The sizes of the databases located in the Data folder are listed below:
bedb_log.ldf 1024 KB
BE_DLO_log.LDF 768 KB
bedb_dat.mdf 92352 KB
BE_DLO.mdf 5504 KB
I am again reviewing the backup exec service account used to run the services. Surprising I run a few test backup jobs against some of the partitions and they run fine without issues. Please advice
06-08-2011 01:09 AM
Did you tried running arepair database using Be utility ?
06-08-2011 09:15 AM
Yes I did run a repair of the DB after reading your forum and the results were fine but this morning I got the message again when the database consistency check process run as indicated below:
(Server: "************") (Job: "Database Maintenance") Summary of database maintenance activity:
* Performed database consistency check for BEDB database
Maintenance has failed: 10, Dump database failed Total elapsed time: 00:00:14
06-09-2011 12:25 AM
Try running a repair install of backup exec from add remove program ,
Run extensive repair of the databse refering the following document http://www.symantec.com/business/support/index?page=content&id=TECH44422