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
On the Windows taskbar, click Start, click Run, type cmd, and then click OK.
At the command prompt, type cd /d %ProgramFiles%\Microsoft Office Communications Server 2007 Speech Server\SDK, and then press ENTER.
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:
|
/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.