Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

My Backup Exec SQl Database is broken Backup Exec 11d and won't start

Created: 10 Dec 2013 | 23 comments

First off my backup exec won't log in any longer I get this when trying to start the backup exec Services

"The Backup Exec Server System Service is not responding The service is either not running or not installed"

In Event viewer I have Event ID 17120 SQL Server Could not Spawn FRuncm thread check the sql server error log and the windows event logs for information about possible related problems.

 

Event id 17826 Could not start the Network Library because of an internal error in the netwpork library. To determine the cause review the errors immediately preceding this one in the error log.

 

Also Event id 17182 TDSSN1 Client initialization failed with error 0x2,

status code 0x1

Operating Systems:

Comments 23 CommentsJump to latest comment

Ouyamaster's picture

There is an MSSQL$$BKUPExec Database in Microsoft SQl Server 2005 that won't start even if I right click it and push start.

pkh's picture

Go to the BE installation directory and use BEUtility to reload the BEDB

Ouyamaster's picture

Ok thanks, but I'm not sure if BEutility is installed. I will check later.

If it isn't where can I get it?  is it under all programs to start it? go to the Beinstallation directory how?

does the utility browse or do I use windows explorer. How exactly do I reload the bedb?

 

is the be installation like c:\programfiles\be ?

Ouyamaster's picture

I tried that and got this see below

 

Recovering the database ended with errors.

Starting database recovery.

Stopping Services

Stopping services for server:EMP-GC-SVR1.

Server:EMP-GC-SVR1, Service:BackupExecAgentBrowser stopped successfully or was not running.

Server:EMP-GC-SVR1, Service:BackupExecJobEngine stopped successfully or was not running.

Server:EMP-GC-SVR1, Service:BackupExecRPCService stopped successfully or was not running.

Server:EMP-GC-SVR1, Service:BackupExecDeviceMediaService stopped successfully or was not running.

Stopping services for server EMP-GC-SVR1 completed.

Performing database recovery for BEDB database.

Error: The database linkage is bad.

Database recovery for server EMP-GC-SVR1 ended with errors.

 

MY DB is still broken anyone have more suggestions?

 

Ouyamaster's picture

I have all the same errors as I did in the beginning.

I have a feeling this is not going to be easy to fix.

Ouyamaster's picture

yep did that see below and I'm still hosed

 

Starting database repair.
Stopping Services
Stopping services for server:EMP-GC-SVR1.
Server:EMP-GC-SVR1, Service:BackupExecAgentBrowser stopped successfully or was not running.
Server:EMP-GC-SVR1, Service:BackupExecJobEngine stopped successfully or was not running.
Server:EMP-GC-SVR1, Service:BackupExecRPCService stopped successfully or was not running.
Server:EMP-GC-SVR1, Service:BackupExecDeviceMediaService stopped successfully or was not running.
Stopping services for server EMP-GC-SVR1 completed.
Performing repair for BEDB database.
Error: The data repair operation failed.
Starting Services
Database repair for server EMP-GC-SVR1 ended with errors.

Ouyamaster's picture

Double whammy see below unable to rebuild

 

 

Starting database utility operation.
Rebuilding indices for BEDB database.
Error: Unable to rebuild indexes.
Database utility for server EMP-GC-SVR1 ended with errors.

 

 

Then Unable to repair

 

Stopping Services
Stopping services for server:EMP-GC-SVR1.
Server:EMP-GC-SVR1, Service:BackupExecAgentBrowser stopped successfully or was not running.
Server:EMP-GC-SVR1, Service:BackupExecJobEngine stopped successfully or was not running.
Server:EMP-GC-SVR1, Service:BackupExecRPCService stopped successfully or was not running.
Server:EMP-GC-SVR1, Service:BackupExecDeviceMediaService stopped successfully or was not running.
Stopping services for server EMP-GC-SVR1 completed.
Performing repair for BEDB database.
Error: The data repair operation failed.
Starting Services
Database repair for server EMP-GC-SVR1 ended with errors.

 

 

Dumping it fails also I tried this
 

http://www.symantec.com/business/support/index?page=content&id=TECH66780&profileURL=https%3A%2F%2Fsymaccount-profile.symantec.com%2FSSO%2Findex.jsp%3FssoID%3D13867754637026phYTSDBPg0aLfuSSwJm2K1uuY51x4tjN7IZz

 

I went back and put my original data folder back because I tried the dump first.

I followed the instructions to back it up so my original data folder is there right now.

The point is neither works, Any more things I can try?

pkh's picture

No.  You should not delete the Data directory.

In BEUtility, there is an option to drop the existing BEDB and start afresh.  Try that first.  Once, BE is up and running. Restore a good copy of the BEDB.BAK and then reload the database from this backup.

Ouyamaster's picture

Read where I said I dropped the database it is also useless.
Anyone have a better idea?

pkh's picture

Read where I said I dropped the database

You have NOT said that you have tried dropping the database.

CraigV's picture

...have you tried a repair of Backup Exed itself through Add/Remove Programs?

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

Ouyamaster's picture

Yes just tried that it also fails with these errors can't even post them all from error log

Before the error log pops up I get The Wizard was interrupted before backup exec could be completely installed. then the error log pops up below. haven't been successful copy entire error log because it is so huge.

 

 

 

 

Symantec Backup Exec (TM) 11.0 for Windows Servers Installation Log

11-24-2008,16:02:32 : C:\VxPushRA\RAWS32\setup.exe
11-24-2008,16:02:32 : CSetupApp::LoadSetupXML
11-24-2008,16:02:32 : CSetupApp::ScanXML
11-24-2008,16:02:32 : C:\VxPushRA\RAWS32\Bin\Setup.xml
11-24-2008,16:02:32 : MSI File Name = WindowsInstaller-KB893803-v2-x86.exe
11-24-2008,16:02:32 : MSI Version = 3.1
11-24-2008,16:02:32 : MSI Package Name = Symantec Backup Exec Remote Agent for Windows Systems.msi
11-24-2008,16:02:32 : System Central Processor = 86
11-24-2008,16:02:32 : Product Type = SETUP_RAWS32
11-24-2008,16:02:32 : Product Name = Symantec Backup Exec Remote Agent for Windows Systems
11-24-2008,16:02:32 : Current Installing GUID ={F72C6003-60EF-448D-AC89-0B69C97678DC}
11-24-2008,16:02:32 : Product Version = 11.0
11-24-2008,16:02:32 : CSetupSupport::IsValidMSIPackage
11-24-2008,16:02:32 : C:\VxPushRA\RAWS32\Symantec Backup Exec Remote Agent for Windows Systems.msi
11-24-2008,16:02:32 : {F72C6003-60EF-448D-AC89-0B69C97678DC}
11-24-2008,16:02:32 : {F72C6003-60EF-448D-AC89-0B69C97678DC}
11-24-2008,16:02:32 : Equal PID
11-24-2008,16:02:32 : The Backup Exec Remote Agent for Windows Systems will be added to the Windows Firewall exception list if the firewall is enabled. For more information see http://seer.support.veritas.com/docs/270139.htm
11-24-2008,16:02:32 : C:\VxPushRA\RAWS32\Symantec Backup Exec Remote Agent for Windows Systems.msi
11-24-2008,16:02:32 : The RAWS installing image version 11.0.6235
11-24-2008,16:02:32 : The RAWS installing PID {F72C6003-60EF-448D-AC89-0B69C97678DC}
11-24-2008,16:02:32 : The RAWS target Image version , PID
11-24-2008,16:02:32 : CSetupSupport::CompareVersionOnImages
11-24-2008,16:02:32 : Installing Version 11.0.6235; (Major=11, Minor=0, Build=6235) > Target Version ; (Major=0, Minor=0, Build=0)
11-24-2008,16:02:32 : Start installing RAWS, AOFO...
11-24-2008,16:02:32 : CSetupApp::GetRAWSHostnameListCommandLine
11-24-2008,16:02:32 : /RANT32: -s /ADVRT:EMPIPMSDBSV;
11-24-2008,16:02:32 : Command Line = INSTALLLEVEL=100 ADDLOCAL=RANT REBOOT=ReallySuppress EXE_ENVOKED=1 ALLUSERS=1 ENABLEADVRT=1 RAWSADVRTISENAMELIST="EMPIPMSDBSV;" TRANSFORMS=C:\VxPushRA\RAWS32\1033.MST
11-24-2008,16:02:34 : === Logging started: 11/24/2008 16:02:34 ===
11-24-2008,16:02:34 : Action 16:02:34: INSTALL.
11-24-2008,16:02:34 : Action start 16:02:34: INSTALL.
11-24-2008,16:02:34 : Action 16:02:34: NetHoodFolder.21AB5BC4_1210_4951_91EB_659439630B03.
11-24-2008,16:02:34 : Action start 16:02:34: NetHoodFolder.21AB5BC4_1210_4951_91EB_659439630B03.
11-24-2008,16:02:34 : Action ended 16:02:34: NetHoodFolder.21AB5BC4_1210_4951_91EB_659439630B03. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: PrintHoodFolder.21AB5BC4_1210_4951_91EB_659439630B03.
11-24-2008,16:02:34 : Action start 16:02:34: PrintHoodFolder.21AB5BC4_1210_4951_91EB_659439630B03.
11-24-2008,16:02:34 : Action ended 16:02:34: PrintHoodFolder.21AB5BC4_1210_4951_91EB_659439630B03. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: RecentFolder.21AB5BC4_1210_4951_91EB_659439630B03.
11-24-2008,16:02:34 : Action start 16:02:34: RecentFolder.21AB5BC4_1210_4951_91EB_659439630B03.
11-24-2008,16:02:34 : Action ended 16:02:34: RecentFolder.21AB5BC4_1210_4951_91EB_659439630B03. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: NetHoodFolder.F298AD5F_2DA0_4620_B6C7_487C4AD977BF.
11-24-2008,16:02:34 : Action start 16:02:34: NetHoodFolder.F298AD5F_2DA0_4620_B6C7_487C4AD977BF.
11-24-2008,16:02:34 : Action ended 16:02:34: NetHoodFolder.F298AD5F_2DA0_4620_B6C7_487C4AD977BF. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: PrintHoodFolder.F298AD5F_2DA0_4620_B6C7_487C4AD977BF.
11-24-2008,16:02:34 : Action start 16:02:34: PrintHoodFolder.F298AD5F_2DA0_4620_B6C7_487C4AD977BF.
11-24-2008,16:02:34 : Action ended 16:02:34: PrintHoodFolder.F298AD5F_2DA0_4620_B6C7_487C4AD977BF. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: RecentFolder.F298AD5F_2DA0_4620_B6C7_487C4AD977BF.
11-24-2008,16:02:34 : Action start 16:02:34: RecentFolder.F298AD5F_2DA0_4620_B6C7_487C4AD977BF.
11-24-2008,16:02:34 : Action ended 16:02:34: RecentFolder.F298AD5F_2DA0_4620_B6C7_487C4AD977BF. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: NetHoodFolder.B770ADD8_4203_438F_955A_9AABAD839036.
11-24-2008,16:02:34 : Action start 16:02:34: NetHoodFolder.B770ADD8_4203_438F_955A_9AABAD839036.
11-24-2008,16:02:34 : Action ended 16:02:34: NetHoodFolder.B770ADD8_4203_438F_955A_9AABAD839036. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: PrintHoodFolder.B770ADD8_4203_438F_955A_9AABAD839036.
11-24-2008,16:02:34 : Action start 16:02:34: PrintHoodFolder.B770ADD8_4203_438F_955A_9AABAD839036.
11-24-2008,16:02:34 : Action ended 16:02:34: PrintHoodFolder.B770ADD8_4203_438F_955A_9AABAD839036. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: RecentFolder.B770ADD8_4203_438F_955A_9AABAD839036.
11-24-2008,16:02:34 : Action start 16:02:34: RecentFolder.B770ADD8_4203_438F_955A_9AABAD839036.
11-24-2008,16:02:34 : Action ended 16:02:34: RecentFolder.B770ADD8_4203_438F_955A_9AABAD839036. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: NetHoodFolder.464186A9_1AEE_4341_A4A4_4FFF20793441.
11-24-2008,16:02:34 : Action start 16:02:34: NetHoodFolder.464186A9_1AEE_4341_A4A4_4FFF20793441.
11-24-2008,16:02:34 : Action ended 16:02:34: NetHoodFolder.464186A9_1AEE_4341_A4A4_4FFF20793441. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: PrintHoodFolder.464186A9_1AEE_4341_A4A4_4FFF20793441.
11-24-2008,16:02:34 : Action start 16:02:34: PrintHoodFolder.464186A9_1AEE_4341_A4A4_4FFF20793441.
11-24-2008,16:02:34 : Action ended 16:02:34: PrintHoodFolder.464186A9_1AEE_4341_A4A4_4FFF20793441. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: RecentFolder.464186A9_1AEE_4341_A4A4_4FFF20793441.
11-24-2008,16:02:34 : Action start 16:02:34: RecentFolder.464186A9_1AEE_4341_A4A4_4FFF20793441.
11-24-2008,16:02:34 : Action ended 16:02:34: RecentFolder.464186A9_1AEE_4341_A4A4_4FFF20793441. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: SystemFolder.246EB7AD_459A_4FA8_83D1_41A46D7634B7.
11-24-2008,16:02:34 : Action start 16:02:34: SystemFolder.246EB7AD_459A_4FA8_83D1_41A46D7634B7.
11-24-2008,16:02:34 : Action ended 16:02:34: SystemFolder.246EB7AD_459A_4FA8_83D1_41A46D7634B7. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: ISSetAllUsers.
11-24-2008,16:02:34 : Action start 16:02:34: ISSetAllUsers.
11-24-2008,16:02:34 : 1: InstallShield - ISSetAllUsers (Begin)
11-24-2008,16:02:34 : 1: Opening Database
11-24-2008,16:02:34 : 1: {60D891E4-6DDD-4931-87B7-52F052473011} 9.0.4367 769
11-24-2008,16:02:34 : 1: Closing Database
11-24-2008,16:02:34 : 1: InstallShield - ISSetAllUsers (End)
11-24-2008,16:02:34 : Action ended 16:02:34: ISSetAllUsers. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: AppSearch. Searching for installed applications
11-24-2008,16:02:34 : Action start 16:02:34: AppSearch.
11-24-2008,16:02:34 : Action ended 16:02:34: AppSearch. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: LaunchConditions. Evaluating launch conditions
11-24-2008,16:02:34 : Action start 16:02:34: LaunchConditions.
11-24-2008,16:02:34 : Action ended 16:02:34: LaunchConditions. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: FindRelatedProducts. Searching for related applications
11-24-2008,16:02:34 : Action start 16:02:34: FindRelatedProducts.
11-24-2008,16:02:34 : Action ended 16:02:34: FindRelatedProducts. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: ValidateProductID.
11-24-2008,16:02:34 : Action start 16:02:34: ValidateProductID.
11-24-2008,16:02:34 : Action ended 16:02:34: ValidateProductID. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: setUserProfileNT.
11-24-2008,16:02:34 : Action start 16:02:34: setUserProfileNT.
11-24-2008,16:02:34 : Action ended 16:02:34: setUserProfileNT. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: setAllUsersProfile2K.
11-24-2008,16:02:34 : Action start 16:02:34: setAllUsersProfile2K.
11-24-2008,16:02:34 : Action ended 16:02:34: setAllUsersProfile2K. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: CostInitialize. Computing space requirements
11-24-2008,16:02:34 : Action start 16:02:34: CostInitialize.
11-24-2008,16:02:34 : Action ended 16:02:34: CostInitialize. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: Set_ALLUSERS.
11-24-2008,16:02:34 : Action start 16:02:34: Set_ALLUSERS.
11-24-2008,16:02:34 : Action ended 16:02:34: Set_ALLUSERS. Return value 1.
11-24-2008,16:02:34 : Action 16:02:34: ResolveSource.
11-24-2008,16:02:34 : Action start 16:02:34: ResolveSource.
11-24-2008,16:02:35 : Action ended 16:02:34: ResolveSource. Return value 1.
11-24-2008,16:02:35 : Action 16:02:35: FileCost. Computing space requirements
11-24-2008,16:02:35 : Action start 16:02:35: FileCost.
11-24-2008,16:02:35 : Action ended 16:02:35: FileCost. Return value 1.
11-24-2008,16:02:35 : Action 16:02:35: IsolateComponents.
11-24-2008,16:02:35 : Action start 16:02:35: IsolateComponents.
11-24-2008,16:02:35 : Action ended 16:02:35: IsolateComponents. Return value 1.
11-24-2008,16:02:35 : Action 16:02:35: CostFinalize. Computing space requirements
11-24-2008,16:02:35 : Action start 16:02:35: CostFinalize.
11-24-2008,16:02:35 : Action ended 16:02:35: CostFinalize. Return value 1.
11-24-2008,16:02:35 : Action 16:02:35: SetODBCFolders. Initializing ODBC directories
11-24-2008,16:02:35 : Action start 16:02:35: SetODBCFolders.
11-24-2008,16:02:35 : Action ended 16:02:35: SetODBCFolders. Return value 1.
11-24-2008,16:02:35 : Action 16:02:35: MigrateFeatureStates. Migrating feature states from related applications
11-24-2008,16:02:35 : Action start 16:02:35: MigrateFeatureStates.
11-24-2008,16:02:35 : Action ended 16:02:35: MigrateFeatureStates. Return value 0.
11-24-2008,16:02:35 : Action 16:02:35: InstallValidate. Validating install
11-24-2008,16:02:35 : Action start 16:02:35: InstallValidate.
11-24-2008,16:02:35 : Action ended 16:02:35: InstallValidate. Return value 1.
11-24-2008,16:02:35 : Action 16:02:35: RemoveExistingProducts. Removing applications
11-24-2008,16:02:35 : Action start 16:02:35: RemoveExistingProducts.
11-24-2008,16:02:35 : Action ended 16:02:35: RemoveExistingProducts. Return value 1.
11-24-2008,16:02:35 : Action 16:02:35: InstallInitialize.
11-24-2008,16:02:35 : Action start 16:02:35: InstallInitialize.
11-24-2008,16:02:35 : Action ended 16:02:35: InstallInitialize. Return value 1.
11-24-2008,16:02:35 : Action 16:02:35: StreamSupportFile_RANT.464186A9_1AEE_4341_A4A4_4FFF20793441.
11-24-2008,16:02:35 : Action start 16:02:35: StreamSupportFile_RANT.464186A9_1AEE_4341_A4A4_4FFF20793441.
11-24-2008,16:02:35 : __stdcall RANT_StreamSupportFile
11-24-2008,16:02:35 : CRANTOperations::SetADPaths
11-24-2008,16:02:35 : CRANTOperations::StreamResourceFiles.
11-24-2008,16:02:35 : C:\VxPushRA\RAWS32\Bin\Resdll_EN.dll
11-24-2008,16:02:35 : C:\DOCUME~1\ADMINI~2.EMP\LOCALS~1\Temp\{F72C6003-60EF-448D-AC89-0B69C97678DC}\Resdll_EN.dll  

Ouyamaster's picture

the very end of the error log

 

12-12-2013,10:42:18 : .NET Framework was detected. Skipping install.
12-12-2013,10:42:19 : Installing Microsoft Report Viewer Redistributable 2005
12-12-2013,10:42:19 : m_bUseNativeClient = 1
12-12-2013,10:44:19 : V-225-204: Could not start the SQL server EMP-GC-SVR1\BKUPEXEC with service name of MSSQL$BKUPEXEC ***To search for information about this error, click here
12-12-2013,10:44:19 : Unable to connect to a SQL Server EMP-GC-SVR1\BKUPEXEC on machine EMP-GC-SVR1.
12-12-2013,10:44:19 : Executing SQL_GetSQLServerEdition.
12-12-2013,10:46:19 : V-225-204: Could not start the SQL server EMP-GC-SVR1\BKUPEXEC with service name of MSSQL$BKUPEXEC ***To search for information about this error, click here
12-12-2013,10:46:19 : V-225-226: Unable to connect to SQL Server. ***To search for information about this error, click here
12-12-2013,10:46:25 : Executing BE_InstallMSXML.
12-12-2013,10:46:25 : msiexec /i "F:\IT Storage\Software\MSXML\msxml.msi" /l*v "C:\Documents and Settings\All Users\Application Data\Symantec\Backup Exec\Logs\MSXML4.log" /qn REBOOT=ReallySuppress
12-12-2013,10:46:25 : V-225-242: Could not find the installer for MSXML. Please make sure the media is complete. ***To search for information about this error, click here
12-12-2013,10:46:25 : V-225-235: MSXML 4.0 SP2 failed to install... Canceling installation. ***To search for information about this error, click here
12-12-2013,10:46:25 : Failed to install third party products.
 

Ouyamaster's picture

Where in the registry can I find my backup exec license keys on 11d?

I found install files for the product.

But they are beyond careless and lost the license keys.

Not that a full reinstall would fix it would probably still be a shot in the dark.

Ouyamaster's picture

I want to verify would my license keys be in \Windows\BESERNUM.XML?

on a windows 2003 Server?

 

Because I read that on another link.

Ouyamaster's picture

Could this be my license key?

 

  <?xml version="1.0" ?>
- <SerialNumbers>
- <SerialNumber>
  <Name>Symantec Backup Exec for Windows Servers</Name>
  <Value>0382500585052669</Value>
  </SerialNumber>
- <SerialNumber>
  <Name>Remote Agent for Windows, Small Business and NetWare Servers</Name>
  <Value>0282859992026660</Value>
  </SerialNumber>
- <SerialNumber>
  <Name>Agent for Microsoft Exchange Server</Name>
  <Value>0582638676925969</Value>
  </SerialNumber>
- <SerialNumber>
  <Name>Remote Agent for Windows, Small Business and NetWare Servers</Name>
  <Value>0582879999026661</Value>
  </SerialNumber>
- <SerialNumber>
  <Name>Remote Agent for Windows, Small Business and NetWare Servers</Name>
  <Value>0782809992026659</Value>
  </SerialNumber>
  </SerialNumbers>

 

Ouyamaster's picture

After further looking it looks like backup exec uses tcp dynamic ports 41626.

 

Which doesn't seem to conflict with other sql databases on the server.

Ouyamaster's picture

Really Screwed. tried to reinstall and got this.

If you Choose to Continue with the Symantec Backup 11d for Windows Servers Removal, you will need to manually detach the bedb database from SQL Server Emp-GC-SVR1\BKUPExec

 

Chose no to abort.

 

is there anyone who has step by step instructions on how to uninstall this and manually detach the database without breaking anything else?

Ouyamaster's picture

Need to know whether I can view a text file,log file, even when backup exec is broken

to see when the last time my Server backed up was.