Running Catrebuildindex on a Backup Exec 2012 media server will execute changes to the Backup Exec BEDB database.

Article:TECH190352  |  Created: 2012-06-04  |  Updated: 2014-09-28  |  Article URL http://www.symantec.com/docs/TECH190352
Article Type
Technical Solution

Product(s)

Issue



Catrebuildindex command line utility in Backup Exec is used to index catalog files. This utility can be used in troubleshooting catalog and restore selection issue.

Running Catrebuildindex on a Backup Exec 2012 media server will execute changes to the Backup Exec BEDB database which will put portions of Backup Exec database into a pre-hotfix state.


Environment



Backup Exec 2012


Cause



Catrebuildindex utility will apply SQL script files to the Backup Exec database that will revert the database back to a pre-hotfix state.

 


Solution



This Issue is Fixed in HF189571 (DDI20120615)

After running catrebuildindex.exe -r  execute the Backup Exec dbupgradebuildtobuild.sql script against the Backup Exec database to apply the correct hotfix changes to the Backup Exec BEDB database. NOTE : Catrebuildindex.exe -r should be run with the Backup Exec Services shutdown.

NOTE! If you have run the catrebuildindex.exe -r  command after you have updated to Hotfix 189571 there is no longer a need to run the dbupgradebuildtobuild.sql script !

Method 1

A) Open a elevated command prompt to \Program Files\Symantec\Backup Exec folder.

B) Issue the following command (Case Sensitive)

 

osql -E -S <servername>\<SQL Instance Name> -dbedb -i dbupgradebuildtobuild.sql

 

Example:  Backup Exec default installation using default BKUPEXEC SQL server instance.

osql -E -S localhost\BKUPEXEC -d bedb -i dbupgradebuildtobuild.sql

 

Method 2

A) Install SQL Express Management Studio on the Backup Exec media server.

B) Locate the 'dbupgradebuildtobuild.sql' script from the following location if backup exec is installed to the default location: C:\Program Files\Symantec\Backup Exec\

C) Open the sql script in notepad and highlight the entire script(Ctrl-A) and then copy(Ctrl-C)

D) Open SQL Express Management Studio and highlight the BEDB under the databases folder.

E) Right-click the BEDB and select 'New query'

F) Paste(Ctrl-V) the script into the query window and click the execute button.

 


Supplemental Materials

SourceETrack
Value2803635
Description

Running Catrebuildindex on a Backup Exec 2012 media server will execute changes to the Backup Exec BEDB database.



Article URL http://www.symantec.com/docs/TECH190352


Terms of use for this information are found in Legal Notices