<!DOCTYPE html> <html> <head> </head> <body> <p>This problem occurred following the migration of Veritas Backup Exec 21 to 22.<br />The previous database was 32-bit and then during the upgrade was upgraded to 64-bit, creating ownership problems on some tables.<br />The following two queries will definitely solve the problem.<strong><br /></strong></p> <p>The Backup Exec console shows a lot of such errors:<br /><strong>ODBC access error. Possible lost connection to database or unsuccessful access to catalog index in the database.</strong></p> <p>Event ID: 34338<br />Backup Exec Alert: Catalog Error<br />(Server: "BE-SERVER01") ODBC access error. Possible lost connection to database or unsuccessful access to catalog index in the database.</p> <p>Event ID: 34326<br />Access to catalog index (Catalog index database) failed.<br />Reason: [Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cursor. CCatRecordSet::Open<br />R:UNION1193Rbecatsegodbcseg_odbc.cpp(1891)<br />{ CALL DeleteCatMediaByMediaGuid( ?, ?, ? ) }</p> <p><strong>Use SQL Studio Management and <span style="text-decoration: underline;">run these two queries with Backup Exec services turned off</span>.</strong></p> <p><strong>Query #1</strong></p> <p>USE bedb<br />exec sp_configure 'clr enabled', 1<br />reconfigure<br />go</p> <p><strong>Query #2</strong></p> <p>USE bedb; <br />EXEC Sp_Changedbowner 'sa';<br />ALTER DATABASE bedb SET TRUSTWORTHY ON<br />go</p> <p><strong>Query #3</strong></p> <p>USE BEDB TRUNCATE TABLE Dbo.alert<br />go</p> </body> </html>
Subscribe
0 Comments
Oldest