MS SQL DB (BEDB) seems to be corrupt

[stevecurtin]

Hi all,

this morning I shut down the services for Backup Exec 2010 R2, and now they will not start. It seemsthat SQL could be corrupt. I am finding the following in the Windows event log (Application). This is running on Windows 2008 R2 server.

Log Name:      System
Source:        Service Control Manager
Date:          3/23/2011 11:05:55 AM
Event ID:      7024
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ServerName

Description:
The SQL Server (BKUPEXEC) service terminated with service-specific error The specified resource name cannot be found in the image file..
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
    <EventID Qualifiers="49152">7024</EventID>
    <Version>0</Version>
    <Level>2</Level>
    <Task>0</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8080000000000000</Keywords>
    <TimeCreated SystemTime="2011-03-23T00:35:55.638791100Z" />
    <EventRecordID>16771</EventRecordID>
    <Correlation />
    <Execution ProcessID="636" ThreadID="9380" />
    <Channel>System</Channel>
    <Computer>ServerName</Computer>
    <Security />
  </System>
  <EventData>
    <Data Name="param1">SQL Server (BKUPEXEC)</Data>
    <Data Name="param2">%%1814</Data>
  </EventData>
</Event>

Does anyone know how to fix this without having to reinistall BU Exec. Historical data is not important.

Thanks

[pkh]

Maybe you can run the BEUtility from the BE installation directory and reload the BEDB from fresh.

[stevecurtin]

Hi pkh,

that didn't seem to work. Output below from the db recovery operation:

----------------------------------------------------------------------------------------------------------------------------

Starting database recovery.
Stopping Services
Starting services for server:ServerName.
Server:ServerName, Service:BackupExecAgentAccelerator started successfully.
Server:ServerName, Service:BackupExecDeviceMediaService failed to start.
Error: (1068) - The dependency service or group failed to start.

Starting services for server ServerName completed with errors.
Error: Starting services for a list of servers failed, see prior errors.
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 database recovery for BEDB database.
Error: The database linkage is bad.
Database recovery for server ServerName ended with errors.

-------------------------------------------------------------------------------------------------------------------

[stevecurtin]

Hi,
the service that fails to start is the Backup Exec Device & Media Service and this is due to the database instance not starting.

[CraigV]

Steve: Try running a repair on the BEDB through BEUTILITY. If that doesn't work, run a repair of the application through Add/Remove Programs.

Also make sure you're still using a domain account to run your services!

[rendersr]

If CraigV's answer are not succesfull, try to restore the newest version of the database, instead of starting all over again. You can find the dump file of the database in the data folder of symantec backup exec (bedb.bak file).

Restore this file can be done with beutility.

R.