create a new bedb_dat.mdf in case of damage?

[vasquez_bln]

Hello forum members.

Can I create a "new bedb_dat.mdf" in case of damage? (BE 12.5)

I tried to repair with BEUTILITY.exe but this will not work.

BE is not starting, services are down. dbrecover.log shows up many tries, but cannot repair (often Execute command failed: 0x80004005)

Thanx for a hint

Eugen

[vasquez_bln]

Here is dbrecover.log attached.

[Backup_Exec1]

Hi

In data folder of backupexec you will see bedb_dat.bak & bedb_log.bak. So first rename the data folder to data_old and then make new folder called Data ensure sql service is stopped

Then in new data folder please copy above 2 files mention

Once done please rename these 2 file to bedb_dat.mdf & bedb_log.ldf which would be you new blank files for backupexec database

Once done please start services & check

Hope that helps

Thanks

[pkh]

There is an option in BEUtility to drop the existing BEDB and create a new one, but this new BEDB will not have any of your jobs, etc.

After creating your new BEDB, you can then try to restore the BEDB from the last backup using BEUtility.

[Riyaj_S]

You may try steps mentioned in following post :

https://www-secure.symantec.com/connect/forums/urgent-server-netbios-name-change-results-be125-not-s...

Hope this helps.

[pkh]

How is this discussion going to solve the user's problem?

[vasquez_bln]

I tried this, but the services do not start (only BackupExecAgentAccelerator, BackupExecDeviceMediaService could not be started)

It seems, that the .BAK files are corrupt too. Is there a chance to build a complete new database?

[vasquez_bln]

I try to translate it from the german version:

is it the point

"rebuild database"

with the following 3 methods of rebuild:

"- best method,

- ignore and load from backup,

- ignore and start new database"

?

And I try "- ignore and start new database" then?

[vasquez_bln]

I tried this, but it does not work. See dbrecover.log attached.

[vasquez_bln]

I did not change the servers name.

[CraigV]

Hi,

Have you tried to reload the BEDB from backup using BEutility? If not, try this and see if it works.

If it doesn't, stop the BE services, rename Data/Catalogs folders to something else, and then restart the services. This will recreate the Data/Catalogs folders again. Once done, see if the services start up correctly.

You can also try a repair of BE using Add/Remove Programs.

You also don't mention the OS on which you run your backups (Server 2008 R2 for instance isn't support with 12.5); if this is a new problem or an existing one; or if you updated the software with any patches.

Thanks!

[pkh]

Try the second recovery method (circled in green), then as the last resort the last method (circled in red).  Note that if you tried the last method, you will loose all your settings, job definitions, etc.

[vasquez_bln]

Meanwhile I tried both, Method 2 & 3, but the result is still the same:

free translatet from german:

database recovery is started
services will be stopped
services für SERVER will be started
Server:SERVER, service:BackupExecAgentAccelerator sucessfuly startet
Server:SERVER, service:BackupExecDeviceMediaService cpuld not be startet
Starting of services for Server SERVER finished with errors

Fehler: Starten der Dienste für eine Liste von Servern fehlgeschlagen; siehe frühere Fehler.
Services for Server SERVER will be stopped.
Server SERVER, Dienst BackupExecAgentBrowser succesfully stopped or are not running

Server SERVER, Service BackupExecJobEngine succesfully stopped or are not running
Server SERVER, Service BackupExecRPCService succesfully stopped or are not running
Server SERVER, Service BackupExecDeviceMediaService esuccesfully stopped or are not runningS

Terminate of Services for Server SERVER finished
Database recovery for BEDB-Datenbank will be started
ERROR: Database-Backup-file is not available
database recovery for Server SERVER finished with errors.

Maybe it has something to do with "ERROR: Database-Backup-file is not available".

Does t´he XML-Files "BEX_SERVER_03959.xml" directly refer to the "B2D*****.bkf" files?

[Colin_Weaver]

Just for info 0x80004005 is usually an Access Denied code - has anyone been messing with the account permissions into SQL (i..e you may not have a corrupt database at alll, just messed up permissions which still apply when you try and recover the bedb?

Also does running SGMON with Device and Media selected whilst trying to start device and media service show anything?

[vasquez_bln]

SGMON shoes following messages:

BEUTILIT: [04.24.12 15:28:14] [0000]     [9028] 04/24/12 15:28:14 "Cluster" key does not appear to be present in the registry
BEUTILIT: [04.24.12 15:28:14] [0000]     [9028] 04/24/12 15:28:14 Failed to open Microsoft cluster ()
BEUTILIT: [04.24.12 15:28:14] [0000]     [9028] 04/24/12 15:28:14 VCS cluster keys do not appear to be present in the registry
BEUTILIT: [04.24.12 15:28:14] [0000]     [9028] 04/24/12 15:28:14 Failed to open VCS cluster ()
 

Cluster Key? I just found this?

1. Stop and disable Microsoft SharePoint Portal Server Search Service. If the search service is required for operation, refer to the second workaround.
2. Perform the following:
a. Stop all Backup Exec services.
b. Browse to C:> Program files> Symantec> Backup Exec and rename the file bedssps2.dll to bedssps2.old
c. Stop and restart all Backup Exec Services and retry the backup.

[Colin_Weaver]

OK that error is en excpected return code if you are not running BE on a cluster. you probably need to look elsewhere in what SGMON captures (possibly with Capture to file selected so that you can look at the full log) to find the problem.

[vasquez_bln]

I found another trace.

BEUTILIT: [04.24.12 16:49:30] [0000]     00-0424:164930:BeUtil status trace: Checking database BEDB
BEUTILIT: [04.24.12 16:49:30] [0000]     00-0424:164930:BeUtil status trace: Execute command: DBCC CHECKDB ('BEDB')
BEUTILIT: [04.24.12 16:49:47] [0000]     00-0424:164947:BeUtil status trace: OpenFromInitializationString Connection String = Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=SERVER\BkupExec;Locale Identifier=1033;Application Name=BEWS DBUTIL hr=0x80004005
BEUTILIT: [04.24.12 16:49:47] [0000]     00-0424:164947:BeUtil status trace: Error connecting to master database: hr = 0x80004005
BEUTILIT: [04.24.12 16:49:47] [0000]     00-0424:164947:BeUtil status trace: Execute command failed: 0x80004005
BEUTILIT: [04.24.12 16:49:47] [0000]     00-0424:164947:BeUtil status trace: OS ERROR: 0x80004005 (-2147467259)
BEUTILIT: [04.24.12 16:49:47] [0000]     00-0424:164947:Operation failed: DBU_ERROR_DATABASE_CHECK_FAILED (11), OS error 0x80004005
BEUTILIT: [04.24.12 16:49:47] [0000]     00-0424:164947:

    **** Error:DBU_ERROR_DATABASE_CHECK_FAILED.
BEUTILIT: [04.24.12 16:49:47] [0000]     00-0424:164947:

    ***** DBU_CloseSession( )

[Colin_Weaver]

Of that is an access deneid message tryign to acecss SQL

Also are you doing this logging whilst using beutility - or just when trying to start Device and Media from the servcies list - as I am a bit surprised to see beutilit listed in that log.

[vasquez_bln]

This is teh result when I try to start the services only:

SERVICES: [05.05.12 13:42:10] [0000]     [9556] 05/05/12 13:42:09 "Cluster" key does not appear to be present in the registry
SERVICES: [05.05.12 13:42:10] [0000]     [9556] 05/05/12 13:42:09 Failed to open Microsoft cluster ()
SERVICES: [05.05.12 13:42:10] [0000]     [9556] 05/05/12 13:42:09 "Cluster" key does not appear to be present in the registry
SERVICES: [05.05.12 13:42:10] [0000]     [9556] 05/05/12 13:42:09 Failed to open Microsoft cluster ()
PVLSVR:   [05.05.12 13:42:10] [0000]     BECRYPTO Base Address is 63100000
PVLSVR:   [05.05.12 13:42:10] [0000]     BECryptoInit: Initialized locks for SSL callbacks
PVLSVR:   [05.05.12 13:42:10] [0000]     BECryptoInit: BECrypto non-FIPS mode successfully enabled.
PVLSVR:   [05.05.12 13:42:10] [0000]       LookupPrivilegeValue( ) found privilege.
PVLSVR:   [05.05.12 13:42:10] [0000]       Privilege is enabled.
PVLSVR:   [05.05.12 13:42:10] [0000]      Checking for 'Restore Files and Directories' privilege.
PVLSVR:   [05.05.12 13:42:10] [0000]       LookupPrivilegeValue( ) found privilege.
PVLSVR:   [05.05.12 13:42:10] [0000]       Privilege is enabled.
PVLSVR:   [05.05.12 13:42:10] [0000]      Checking for 'Create a Token Object' privilege.
PVLSVR:   [05.05.12 13:42:10] [0000]       LookupPrivilegeValue( ) found privilege.
PVLSVR:   [05.05.12 13:42:10] [0000]       Privilege is enabled.
PVLSVR:   [05.05.12 13:42:10] [0000]      Checking for 'Manage Auditing and Security Log' privilege.
PVLSVR:   [05.05.12 13:42:10] [0000]       LookupPrivilegeValue( ) found privilege.
PVLSVR:   [05.05.12 13:42:10] [0000]       Privilege is enabled.
PVLSVR:   [05.05.12 13:42:10] [0000]      Checking for 'Take ownership of files and other objects' privilege.
PVLSVR:   [05.05.12 13:42:10] [0000]       LookupPrivilegeValue( ) found privilege.
PVLSVR:   [05.05.12 13:42:10] [0000]       Privilege is enabled.
PVLSVR:   [05.05.12 13:42:10] [0000]      Not checking for 'Act as part of the operating system' privilege as it is not needed for this environment.
PVLSVR:   [05.05.12 13:42:10] [0000]     [6364] 05/05/12 13:42:10 "Cluster" key does not appear to be present in the registry
PVLSVR:   [05.05.12 13:42:10] [0000]     [6364] 05/05/12 13:42:10 Failed to open Microsoft cluster ()
PVLSVR:   [05.05.12 13:42:10] [0000]     [6364] 05/05/12 13:42:10 VCS cluster keys do not appear to be present in the registry
PVLSVR:   [05.05.12 13:42:10] [0000]     [6364] 05/05/12 13:42:10 Failed to open VCS cluster ()
 

[vasquez_bln]

Until today there ist no solution for this problem.

What can I do?