Forum Discussion

AdminC's avatar
AdminC
Level 3
12 years ago
Solved

Backup Exec Alert: Database Maintenance Failure

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 
 
 

 

Backing Up
Backup and Recovery
Backup Exec
Error messages
Windows Server (2003-2008)
  • Kunal_Mudliyar1's avatar
    Kunal_Mudliyar1
    12 years ago

    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.

     

     

     

     

     

     

15 Replies

Sort By
  • Kunal_Mudliyar1's avatar
    Kunal_Mudliyar1
    Level 6
    12 years ago

    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's avatar
    AdminC
    Level 3
    12 years ago

    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 
  • AdminC's avatar
    AdminC
    Level 3
    12 years ago

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

  • Kunal_Mudliyar1's avatar
    Kunal_Mudliyar1
    Level 6
    12 years ago

    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's avatar
    AdminC
    Level 3
    12 years ago

    @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's avatar
    Kunal_Mudliyar1
    Level 6
    12 years ago

    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's avatar
    AdminC
    Level 3
    12 years ago

    @kunal.Mudliyar

    Thanks I will Run It now, 

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

  • AdminC's avatar
    AdminC
    Level 3
    12 years ago
    @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.