Modifying the database for non-english searches – Grass Valley Aurora Browse v.7.0 Installation User Manual

Page 150

Advertising
background image

150

Aurora Browse Installation and Configuration Guide

April 6, 2010

Chapter 6 Database and Recovery Planning

9. Replace all occurrences of the old server name with the new server name, and save

the file.

10.In SSMS, right-click on

Integration Services Stored Packages| MSDB|Maintenance

Plans

.

11.From the context menu, select

Import Package

.

12.Specify the same path as you did in step 6.

13.If the modified maintenance plan has the same name as the original, a warning is

displayed indicating that the Maintenance Plan will be overwritten. Click

OK

.

CAUTION: Do not import the package file (e.g.
MediaFramemaintenancePlan.dtsx) into another maintenance plan.

Modifying the database for non-English searches

To enable the MediaFrame database to allow searches in languages such as Chinese,
the database needs to be modified. Because it will take some time to re-index the data,
this procedure should be performed when the system is not in prime use. This
procedure will not affect operations aside from search functionality.

To modify the database for non-English searches, follow these steps.

1. Open the Microsoft SQL Server Management Studio tool.

2. Select

Databases | MediaFrame | Tables

.

3. Right-click on the

dbo.MetadataTbl

table.

4. Select

Full-Text Index | Properties

. The Full-Text Index Properties dialog box

displays.

5. Select the

Columns

page.

6. For every column that has a check box, change the language in the Language for

Advertising