Hello,
Our BackupExec v 9.1 using MSSQL gives the following error when the Backup Exec Device & Media Service starts. It looks like the database is corrupt. What is the best course of action? If needed I will just create a new database, but it looks like the data file and log file are in the data directory. Here's the event from the service error and the log file and the dbrecover.log file...
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7023
Date:11/1/2006
Time:3:47:16 PM
User:N/A
Computer:ASPENSERVER
Description:
The Backup Exec Device & Media Service service terminated with the following error:
The database specified does not exist.
Backup Exec Database Recovery
11/01/06 15:47:15
-----------------------------
Initializing...
Data for BE database:
Structure size: 3532
Media Server : ASPENSERVER
Node, if clust:
SQL Server : ASPENSERVER
Instance Name : BkupExec
SQL Instance : ASPENSERVER\BkupExec
SQL Service : MSSQL$BkupExec
Database : BEDB
App Data Path : E:\Program Files\VERITAS\Backup Exec\NT\Data
Database Path :
Database File : E:\Program Files\VERITAS\Backup Exec\NT\Data\BEDB_dat.mdf
Database Log : E:\Program Files\VERITAS\Backup Exec\NT\Data\BEDB_log.ldf
Backup File : E:\Program Files\VERITAS\Backup Exec\NT\Data\BEDB.bak
Base File : E:\Program Files\VERITAS\Backup Exec\NT\Data\BEDB_dat.bak
Is Local : TRUE
IsDatabaseMgr : TRUE
Recover database using best method..
Database BEDB does not exist
Fixing up any database linkage problems for 'BEDB'
Execute command: declare @@stemp as varchar(32)
select @@stemp = isnull(convert(varchar,databasepropertyex('BEDB','status')),'NOT EXIST')
print 'Database status: ' + @@stemp
if @@stemp <> 'ONLINE' and @@stemp <> 'NOT EXIST'
begin
print 'Forcing database detach'
EXEC sp_detach_db 'BEDB'
end
Database status: NOT EXIST
File Exist Check: E:\Program Files\VERITAS\Backup Exec\NT\Data\BEDB_dat.mdf
File Exist: TRUE
Attach database BEDB
File Exist Check: E:\Program Files\VERITAS\Backup Exec\NT\Data\BEDB_dat.mdf
File Exist: TRUE
File Exist Check: E:\Program Files\VERITAS\Backup Exec\NT\Data\BEDB_log.ldf
File Exist: TRUE
Execute command: sp_attach_db 'BEDB','E:\Program Files\VERITAS\Backup Exec\NT\Data\BEDB_dat.mdf','E:\Program Files\VERITAS\Backup Exec\NT\Data\BEDB_log.ldf'
The LSN (203:431:1) passed to log scan in database 'BEDB' is invalid.
Execute command failed: 0x80004005
OS ERROR: 0x80004005 (-2147467259)
Deinitialize...
-----------------------------
Process completed
11/01/06 15:47:16
Status: DBU_ERROR_DATABASE_ATTACH_FAILED
-----------------------------
