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: 2012-10-17|||||Article URL http://www.symantec.com/docs/TECH190352|
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.
Backup Exec 2012
Catrebuildindex utility will apply SQL script files to the Backup Exec database that will revert the database back to a pre-hotfix state.
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! 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 !
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
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.
Article URL http://www.symantec.com/docs/TECH190352