Microsoft KB Archive/929981

= How to migrate the Targeted Broadcast Message Service (TBMS) in Microsoft TV Foundation Edition 1.7 =

Article ID: 929981

Article Last Modified on 1/25/2007

-

APPLIES TO


 * Microsoft TV Foundation Edition 1.7 Service Pack 1

-



INTRODUCTION
In Microsoft TV Foundation Edition 1.7, the Targeted Broadcast Message Service (TBMS) may be migrated from one server farm to another. This article discusses how to migrate TBMS from one server farm to another.



MORE INFORMATION
TBMS is configured by using the following files:
 * Tbms.xml

This file is part of the standard Microsoft TV Foundation Edition configuration. This file specifies the Motorola OM-1000 out-of-band multiplexers/modulators to which messages may be sent.
 * Tbms.mdb

This file is a database of messages that have been sent to the set-top boxes. This database also contains message counters. The set-top box uses these counters to determine which messages are new and which messages have already been viewed. The TBMS database is managed by the TBMS application Graphical User Interface (GUI).

To prevent set-top boxes from viewing messages more than one time after you migrate TBMS, make sure that the following conditions are true:
 * Only one Microsoft TV Foundation Edition server farm is configured to communicate with the OM-1000s.
 * The most up-to-date TBMS database resides on the server farm that is active.
 * You have removed OM-1000 support from the &quot;old&quot; or source server farm.
 * You have added OM-1000 support to the &quot;new&quot; or destination server farm.

How to migrate TBMS from one server farm to another
Notes
 * “Source server farm” refers to the system from which you are moving TBMS.
 * “Destination server farm” refers to the system to which you are moving TBMS.
 * The TBMS extension document and .chm file state that the Tbmsdb.mdb file can be backed up and restored by using the Microsoft Access GUI. However, Microsoft Access is not installed on the Microsoft TV servers. Therefore, you must perform backup and restore operations by stopping services on the Microsoft TV stream engine computer and then copying the Tbmsdb.mdb file while the services are stopped.

 Back up the Microsoft TV configuration files and the TBMS databases on the source and destination Microsoft TV server farms. To do this, follow these steps:  Start the Microsoft TV command prompt. Move to the Configuration directory by typing the following command:

cd configuration

 Create a copy of the current configuration by using the tvs command in a directory whose name uses the _Rollback format. For example, run the following command in the 20061218_Rollback directory:

tvs get-config 20061218_Rollback

 Create a backup directory that resembles the following:

C:\Program Files\Microsoft TV\Foundation Server 1.7 NA\TBMSDB\20061218_Backup

 At the command prompt, type tvs stop . In Windows Explorer, locate the C:\Program Files\Microsoft TV\Foundation Server 1.7 NA\TBMSDB directory. This directory contains the TBMS database. If the Tbmsdb.ldb lock file is present in this directory, click Start, click Run, type Services.msc, right-click MSTV Targeted Broadcast Message Service, and then click Restart. After the service is restarted, the Tbmsdb.ldb lock file should no longer be present.</li> Right-click MSTV Targeted Broadcast Message Service, and then click Stop.</li> Copy the C:\Program Files\Microsoft TV\Foundation Server 1.7 NA\TBMSDB\Tbmsdb.mdb file to the directory that you created in step 1d.</li> At the command prompt, type tvs start .</li></ol> </li> Remove OM-1000 support from the source server farm. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Start the Microsoft TV command prompt.</li> To change to the Configuration directory, type cd configuration .</li> Create a working copy of the current configuration by running the tvs command in a directory whose name uses the _Ver1 format. For example, type the following command in the 20061218_Ver1 directory:

tvs get-config 20061218_Ver1

</li> Use Notepad to open the 20061218_Ver1\Tbms.xml file.</li> Put a comment character on all lines for the XML node that are named destinations. Use Internet Explorer to open the file, and then confirm that all destination nodes are commented.</li> At the command prompt, run the following commands to commit the changes and to restart services. Press ENTER after each command.

tvs validate-config 20061218_ver1

tvs commit-config 20061218_ver1

tvs stop all

tvs start all

</li> Start the TBMS application, and then click New to create a new message. Confirm that no OM-1000s are present.

Note You cannot create a message if no OM-1000s are selected.</li></ol> </li> Add OM-1000 support to the destination server farm. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Start the Microsoft TV command prompt.</li> To move to the Configuration directory, type cd configuration .</li> Create a working copy of the current configuration by running the tvs command in a directory whose name uses the _Ver1 format. For example, type the following command in the 20061218_Ver1 directory:

tvs get-config 20061218_Ver1

</li> Use Notepad to open the 20061218_ver1\Tbms.xml file.</li> <li>On all lines for the XML node that are named destinations, insert the OM-1000 destination sections that were commented out from the source Tbms.xml file.</li> <li>At the command prompt, run the following commands to commit the changes and to restart services. Press ENTER after each command.

tvs validate-config 20061218_ver1

tvs commit-config 20061218_ver1

tvs stop all

tvs start all

</li> <li>Start the TBMS application, and then click New to create a new message. Confirm that OM-1000s are present and may be selected.</li></ol> </li> <li>Copy the TBMS database from the source server farm to the destination server farm. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>At a command prompt on the destination server farm, type the following command:

tvs stop C:\Program Files\Microsoft TV\Foundation Server 1.7 NA\TBMSDB

</li> <li>In Windows Explorer, locate the C:\Program Files\Microsoft TV\Foundation Server 1.7 NA\TBMSDB directory. This directory contains the TBMS database. If the Tbmsdb.ldb lock file is present in the directory, click Start, click Run, type Services.msc, right-click MSTV Targeted Broadcast Message Service, and then click Restart. After the service is restarted, the Tbmsdb.ldb lock file should no longer be present.</li> <li>Right-click MSTV Targeted Broadcast Message Service, and then click Stop.</li> <li>Right-click the Tbmsdb.mdb file, click Security, and then confirm that the following three accounts have FULL CONTROL permissions. <ul> <li>g_ _tbms</li> <li>administrators</li> <li>system</li></ul>

Note  will be site specific. For example, for a domain that is named evt17, the account name is g_evt17_tbms.

</li> <li>Copy the Tbmsdb.mdb file from the source stream engine computer to the destination stream engine computer. Copy the file to the C:\Program Files\Microsoft TV\Foundation Server 1.7 NA\TBMSDB directory.</li> <li>At the command prompt, type tvs start .</li> <li>On the destination server farm controller, run the TBMS application, and then confirm that messages are present.</li></ol> </li></ol>

How to roll back the system if the migration is unsuccessful
<ol> <li>Remove OM-1000 support from the destination server farm. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Start the Microsoft TV command prompt.</li> <li>To move to the Configuration directory, type cd configuration .</li> <li>Create a working copy of the current configuration by using the tvs command in a directory whose name uses the _Ver2 format. For example, type tvs get-config 20061218_Ver2 in the 20061218_Ver2 directory.</li> <li>Copy the Tbms.xml file from the rollback directory. For example, copy the Tbms.xml file from the 20061218_Rollback directory to the 20061218_Ver2 directory.</li> <li>At the command prompt, run the following commands to commit the changes and to restart services:

tvs validate-config 20061218_ver2

tvs commit-config 20061218_ver2

tvs stop all

tvs start all

</li> <li>Start the TBMS application, and then click New to create a new message. Confirm that no OM-1000s are present.</li></ol> </li> <li>Add OM-1000 support to the source server farm. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> <li>Start the Microsoft TV command prompt.</li> <li>To move to the Configuration directory, type cd configuration .</li> <li>Create a working copy of the current configuration by using the tvs command in a directory whose name uses the _Ver2 format. For example, in the 20061218_Ver2 directory, type tvs get-config 20061218_Ver2 .</li> <li>Copy the Tbms.xml file from the rollback directory. For example, copy the 20061218_Rollback file to the 20061218_Ver2 directory.</li> <li>At a command prompt, run the following commands to commit the changes and to restart services. Press ENTER after each command.

tvs validate-config 20061218_ver2

tvs commit-config 20061218_ver2

tvs stop all

tvs start all

</li> <li>Start the TBMS application, and then click New to create a new message. Confirm that OM-1000s are present.</li></ol> </li> <li>Restore the TBMS databases on the source and destination server farms. Follow these steps on the source and destination stream engine computers: <ol style="list-style-type: lower-alpha;"> <li>Start the Microsoft TV command prompt, and then type tvs stop .</li> <li>In Windows Explorer, locate the C:\Program Files\Microsoft TV\Foundation Server 1.7 NA\TBMSDB directory. This folder contains the TBMS Database. If the Tbmsdb.ldb lock file is present, click Start, click Run, type Services.msc, right-click MSTV Targeted Broadcast Message Service, and then click Restart. After the service is restarted, the Tbmsdb.ldb lock file should no longer be present.</li> <li>Right-click MSTV Targeted Broadcast Message Service again, and then click Stop.</li> <li>Copy the Tbmsdb.mdb file from the C:\Program Files\Microsoft TV\Foundation Server 1.7 NA\TBMSDB\YYYYMMDD_Backup directory to the C:\Program Files\Microsoft TV\Foundation Server 1.7 NA\TBMSDB directory.</li> <li>At the command prompt, type tvs start .</li> <li>Start the TBMS application, and then confirm that the messages are present as expected.</li></ol> </li></ol>

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

Keywords: kbhowto kbinfo KB929981

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.