Grass Valley GV STRATUS Installation v.3.1 - Manual (Page 309)

Updating the maintenance plan after renaming the server
Before updating the maintenance plan, verify that you have has SQL Server Integration Services
(SSIS) installed. SSIS is part of the typical SQL Server installation.
If you rename the GV STRATUS server, you must update the maintenance plan. Renaming the
server does not alter the maintenance plan.
The maintenance plan update can be divided into three main sections:
Stage 1: Exporting the maintenance plan to a file
Stage 2: Updating the file with the new server name
Stage 3: Importing the modified plan
1. Open SQL Server Management Studio (SSMS) on the server.
2. Open a connection to the local Database Engine and to the local Integration Services. (Use the
Connect drop down button in SSMS.)
3. Locate the STRATUSMaintenancePlan under Integration Services | Stored Packages | MSDB |
Maintenance Plans .
4. Right-click on the maintenance plan to bring up the context menu, and select Export Package .
5. Select File System in the Package Location drop-down list.
6. Enter or browse to a desired location in the Package Path text box.
7. Click OK and verify that the file was created by navigating to the specified location.
8. Open the file in a text editor, such as Notepad.
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 .
NOTE: Do not import the package file (e.g. STRATUSMaintenancePlan.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.
1. Open the Microsoft SQL Server Management Studio tool.
2. Open Databases | MediaFrame | Tables nodes.
3. Right-click the dbo.MetadataTbl table and select Full-Text Index | Properties .
The Full-Text Index Properties dialog box opens.
4. Select the Columns page.
2013 12 19 GV STRATUS Installation and Service Manual 309
Administering and maintaining the GV STRATUS system