DBCC CHECKDB (msdb) found 10 errors and repaired 0 errors

[Veritas_User]

When the Windows 2000 server running BackupExec 9.1 Rev. 4691 backs up itself the following errors occurs...

Backup - BACKUPSVR\BKUPEXEC An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'msdb'.

Event Type:Error
Event Source:Backup Exec
Event Category:None
Event ID:57859
Date:7/28/2005
Time:6:49:15 AM
User:N/A
Computer:BACKUPSVR
Description:
An error occurred while executing the following query: "DBCC CHECKDB()".
On server: "BACKUPSVR\BKUPEXEC".
SQL error number: "09E8".
SQL error message: "DBCC results for 'msdb'.
".

Event Type:Information
Event Source:MSSQL$BKUPEXEC
Event Category:(2)
Event ID:17055
Date:7/28/2005
Time:6:49:15 AM
User:DOMAIN\backupexec
Computer:BACKUPSVR
Description:
8957 :
DBCC CHECKDB (msdb) executed by DOMAIN\backupexec found 10 errors and repaired 0 errors.

Specifically this is the C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\msdbdata.mdf database that is part of the MSDE version of SQL that was installed by BackupExec that is associated with the following BackupExec databases: BEDB, Master, Model, MSDB.

How can I repair this database? Thanks.

[Renuka_-]

Hello,

in order to repair the backup exec database please refer to the following technote:
http://support.veritas.com/docs/265180

Additional Information :
For information on the recent VERITAS Backup Exec security vulnerabilities, including links to the downloads for the necessary hotfixes, please refer to the following document:
Patch summary for Security Advisories VX05-001, VX05-002, VX05-003, VX05-005, VX05-006, VX05-007

http://seer.support.veritas.com/docs/277429.htm

NOTE : If we do not receive your reply within two business days, this post would be marked assumed answeredand would be moved toanswered questions pool.

[Veritas_User]

Again, I am specifically referring to the msdb database. The database repair done by 265180 does not address this particular database.

Starting database repair.
Stopping Services
Stopping services for server:BACKUPSVR.
Server:BACKUPSVR, Service:BackupExecJobEngine stopped successfully or was not running.
Server:BACKUPSVR, Service:BackupExecRPCService stopped successfully or was not running.
Server:BACKUPSVR, Service:BackupExecDeviceMediaService stopped successfully or was not running.
Stopping services for server BACKUPSVR completed.
Performing repair for BEDB database.
Starting Services
Starting services for server:BACKUPSVR.
Server:BACKUPSVR, Service:BackupExecDeviceMediaService started successfully.
Server:BACKUPSVR, Service:BackupExecRPCService started successfully.
Server:BACKUPSVR, Service:BackupExecJobEngine started successfully.
Starting services for server BACKUPSVR completed.
Database repair for server BACKUPSVR completed.

Backup Exec Database Recovery
07/29/05 08:44:21
-----------------------------
Initializing...
Data for BE database:
Structure size: 3532
Media Server : BACKUPSVR
Node, if clust:
SQL Server : BACKUPSVR
Instance Name : BkupExec
SQL Instance : BACKUPSVR\BkupExec
SQL Service : MSSQL$BkupExec
Database : BEDB
App Data Path : C:\Program Files\VERITAS\Backup Exec\NT\Data
Database Path :
Database File : C:\Program Files\VERITAS\Backup Exec\NT\Data\BEDB_dat.mdf
Database Log : C:\Program Files\VERITAS\Backup Exec\NT\Data\BEDB_log.ldf
Backup File : C:\Program Files\VERITAS\Backup Exec\NT\Data\BEDB.bak
Base File : C:\Program Files\VERITAS\Backup Exec\NT\Data\BEDB_dat.bak
Is Local : TRUE
IsDatabaseMgr : TRUE
Recover database using best method..
Database BEDB is ONLINE
Getting files for database 'BEDB'
Database exists - nothing to do
Setting up for IDR...
Getting files for database 'master'
Getting files for database 'model'
File Exist Check: C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\master$4idr
File Exist: TRUE
File Exist Check: C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\mastlog$4idr
File Exist: TRUE
File Exist Check: C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\model$4idr
File Exist: TRUE
File Exist Check: C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Data\modellog$4idr
File Exist: TRUE
Deinitialize...

-----------------------------
Process completed
07/29/05 08:44:22
Status: DBU_SUCCESS
-----------------------------

[priya_khire]

Hello,

Have you also installed SQL on the Backup Exec server?
Since when does the error occur?
Follow the steps given below:

1. Install MDAC 2.8 on the server from the following link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en

2. Install SP 2 for backup exec 9.1 in case it is not already installed. Here is the link for the download:

VERITAS Backup Exec (tm) 9.1 for Windows Servers revision 4691 - Service Pack 2
http://support.veritas.com/docs/275247

If the issue persists, revert with details.

Note : If we do not receive your reply within two business days, this post would be marked ‘assumed answered’ and would be moved to ‘answered questions’ pool.

Regards.

[Veritas_User]

No, only MSDE installed by BackupExec. The issue began several weeks ago. MDAC 2.8 has now been installed but the issue is unchanged. SP2 for BackupExec 9.1 was installed last week, but the issue is unchanged.

[Sharvari_Deshmu]

Hello,

please try doing a reload from base and then verify the result.

please see the technote below:
http://support.veritas.com/docs/254014


Note: All media sets, backup-to-disk folders, and other settings will have to be created or configured again.

Thanks,

NOTE : If we do not receive your reply within two business days, this post would be marked assumed answered and would be moved to answered questions pool.