Backup Exec Alert: Database Maintenance Failure

[AdminC]

Hello Folks 

Im running A Windows server 2003 small bussines, i have SQL server 2005, and microsoft exchange. 

WIndows Event Viewer error. 

Event ID 57348

Backup Exec Alert: Database Maintenance Failure

(Server: "xxxxxxx") (Job: "Database Maintenance") Summary of database maintenance activity:

* Saved contents of BEDB database

* Saved contents of BE_DLO database

* Deleted expired data for BE_DLO database:

* Deleted expired data for BEDB database:

     1 expired audit logs were deleted

     0 expired reports were deleted

     0 expired job histories were deleted

     1 expired alert histories were deleted

     3 expired job logs were deleted

Maintenance has failed: -536837662, -536837662: :: -2147217900:Internal Query Processor Error: The query processor encountered an unexpected error during execution.

Total elapsed time: 00:00:08 

MY daily Backup is working fine, Without any error. 

Does anybody has encounter the same error. 

Any Suggestions, would be greatly appreciated 

[lmosla]

Hello AdminC,

Are you using Backup Exec 2012? If so please upgrade to Backup Exec 2012 revision 1798 Service Pack 2 - http://www.symantec.com/docs/TECH203155

see this error that occurs in Backup Exec 2012 when the Database maintenance occurs and an alert is generated that the maintenance has failed.  http://www.symantec.com/docs/TECH201551

[Kunal_Mudliyar1]

Can you please confirm your backup exec version?

It appears some sort of BEDB corruption. Please try performing extensive repair of database by going through following document:

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

Also, is there any other application using SQL databases on this server? Also, go to alerts tab on Backup Exec and clear all the alerts there, after extensive repair.

[AdminC]

Im running  backup exec 2010,

Microsoft SQL Server Management Studio Express 9.00.2047.00

Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)

Microsoft MSXML 2.6 3.0 4.0 6.0 

Microsoft Internet Explorer 8.0.6001.18702

Microsoft .NET Framework 2.0.50727.3643

Operating System 5.2.3790

Windows 2003 for small business server 

[Kunal_Mudliyar1]

Are you using DLO(Desktop and Laptop Option ) too?

[AdminC]

A don't Think so, but to double check, is that part backup exec?

[Kunal_Mudliyar1 · Accepted solution]

Yes it is a part of backup exec 2010 but need a license to work.

If you are not using it

= Stop the sql server (bkupexec) service

= Goto the symantec directory

= Locate the data folder rename BE_DLO.mdf to BE_DLO.mdf.old

= Locate the data folder rename BE_DLO_log.Ldf to BE_DLO_log.Ldf.old

Now

= Restart the sql server and all the backup exec server

Manually run the Database Maintenance to check if it works.

Goto

Tools > Options >Database Maintenance

Change the Peform Maintenance time to 5 mins ahead from your current time.

You can change it backup to 4 am later.

[AdminC]

@Kunal.Mudliyar 

Ok rename the files, restarted the server, 

Can i run Beutility and run repair the data base of should i wait till tomorrow to see if the data maintenance ran correctly?

[Kunal_Mudliyar1]

Yes please run the beutility repair as well

====

Database Maintenance run at 4 am by default everyday,

You can Manually run the Database Maintenance now  to check if it works.

If it works not it will work at 4 am as well

Goto

Tools > Options >Database Maintenance

Change the Peform Maintenance time to 5 mins ahead from your current time.

You can change it backup to 4 am later.

[AdminC]

@kunal.Mudliyar

Thanks I will Run It now, 

My database maitenance was at 3 am, i change it to 3:10 Am.  

[AdminC]

@kunal.Mudliyar

OK I ran the utility repair the database this are the results 

Starting database repair.

Stopping Services

Stopping services for server:SERVERNAME.

Server:SERVERNAME, Service:BackupExecAgentBrowser stopped successfully or was not running.

Server:SERVERNAME, Service:BackupExecJobEngine stopped successfully or was not running.

Server:SERVERNAME, Service:BackupExecRPCService stopped successfully or was not running.

Server:SERVERNAME, Service:BackupExecDeviceMediaService stopped successfully or was not running.

Stopping services for server SERVERNAME completed.

Performing repair for BEDB database.

Starting Services

Starting services for server:SERVERNAME.

Server:SERVERNAME, Service:BackupExecDeviceMediaService started successfully.

Server:SERVERNAME, Service:BackupExecRPCService started successfully.

Server:SERVERNAME, Service:BackupExecJobEngine started successfully.

Server:SERVERNAME, Service:BackupExecAgentBrowser started successfully.

Starting services for server SERVERNAME completed.

Database repair for server SERVERNAME completed.

[Kunal_Mudliyar1]

This look good...

Can you run a maintainance now?

[AdminC]

@kunal.Mudliyar 

Summary of database maintenance activity:

* Saved contents of BEDB database

* Saved contents of BE_DLO database

* Deleted expired data for BE_DLO database:

* Deleted expired data for BEDB database:

     1 expired audit logs were deleted

     0 expired reports were deleted

     131 expired job histories were deleted

     3 expired alert histories were deleted

     0 expired job logs were deleted

Total elapsed time: 00:00:06

I checked the event viewer and no database maintenance error. 

[Kunal_Mudliyar1]

Thats good news! Now...schedule the database maintenance back to your time which is 3 am...

You should not see this error

I guess it happened due to corrupt DLO database.

You can choose to uninstall the DLO option too from the Backup exec, however I would suggest you not do uninstall it and leave it the way it is.

[AdminC]

Ok. Will Re schedule the dabase maintenance and will check back tomorrow for any errors, i will post tomorrow the results thanks so much Kunal.Mudliyar  

[AdminC]

Good Morning Kunal.Mudliyar   ok now the databese maintenance is running without errors thank you for your help!!!