Udostępnij za pośrednictwem


Purge the Tuning Database

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Use the command-line tool MssDataPurge.exe to purge data from a Speech Server tuning database. The default installation path for the Speech Server Log Tools is %ProgramFiles%\Microsoft Office Communications Server 2007 Speech Server\SDK.

To install Speech Server Log Tools, install Speech Server and then select Data Processing Utilities. The default installation path for Speech Server Log Tools is %ProgramFiles%\Microsoft Office Communications Server 2007 Speech Server\SDK.

To run MssDataPurge.exe

  1. On the Windows taskbar, click Start, click Run, type cmd, and then click OK.

  2. At the command prompt, type cd /d %ProgramFiles%\Microsoft Office Communications Server 2007 Speech Server\SDK, and then press ENTER.

  3. Enter the appropriate MssDataPurge.exe syntax, and then press ENTER.

    To interrupt execution, press CTRL+C.

Note??????Purged sessions cannot be imported back into the tuning database if there are existing sessions in the tuning database imported from the same log file as the purged sessions.

Syntax

MssDataPurge

/remove:level

/cycle:name

/pre:datetime

/post:datetime

/database:name

[/server: name]

[/username:value]

[/password:value]

[/connect:seconds]

[/timeout:seconds]

[/disableindexes]

[/rebuildindexes]

[/noencrypt]

[/nologo]

[quiet]

[/verbose]

[/help]

Parameters

Parameter Description

/remove:level

Specifies the level of purging to perform. Only one value can be provided. Required.

Possible levels:

  • all - purge all data.
  • tuning - purge tuning data and all audio.
  • audio - purge all audio.
  • nonrecoaudio - purge only non-engine recognition audio.
  • promptaudio - purge only prompt audio.
  • grammars - purge only grammars.
  • rerecognition - purge a re-recognition cycle.

/cycle:name

Specifies the name of the re-recognition cycle to purge. Required if /remove:rerecognition is specified.

/pre:datetime

Specifies that data before this datetime is purged. Enter this parameter only if the /post parameter is not entered. Required if the /post parameter is omitted.

/post:datetime

Specifies that data after this datetime is purged. Enter this parameter only if the /pre parameter is not entered. Required if the /pre parameter is omitted.

/database:name

Specifies the name of the database from which data is purged. Required.

/server:name

Specifies the network name of the Microsoft SQL??Server host. If omitted, the local server is assumed. Optional.

/username:value

Specifies the user name for SQL??Server authentication. Optional.

/password: value

Specifies the password for SQL??Server authentication. Optional.

/connect:seconds

Specifies the time-out, in seconds, for the SQL??Server connection. Defaults to 300 seconds. Optional.

/timeout:seconds

Specifies the time-out, in seconds, for SQL??Server commands that execute during the purging process. Defaults to 900 seconds. Optional.

/disableindexes

Disables non-clustered indexes prior to data purge. Consider using this switch when the amount of data to purge is reasonably large compared with the size of the existing SQL??Server database. Optional.

/rebuildindexes

Rebuilds non-clustered indexes after data purge. Consider using this switch when the amount of data to purge is reasonably large compared with the size of the existing SQL??Server database. Optional.

/noencrypt

Specifies that communication with SQL??Server is not encrypted. By default, an encrypted protocol is used. Optional.

/nologo

Specifies that the copyright message is suppressed. Optional.

/verbose

Specifies that the file overwrite warning is suppressed. (Short form: /v) Optional.

/help

Specifies that a message displaying usage help is displayed. (Short form: /h or /?) Optional.

Remarks

Any argument with a space in it must be delimited with quotation marks.

See Also

Concepts

Tuning Database

Other Resources

Management of Tuning Data