The database purge utility for a SQL Server event database
is implemented as a stored procedure.
Before you begin
To use the utility for a SQL Server database, you must have
the osql utility installed on the SQL Server client. Refer to the
SQL Server documentation for more information.
Note: Do not use the
isql utility for running the database purge stored procedure.
Procedure
To purge the inactive bucket, run the stored procedure
using the osql utility: osql -Sserver_name -Udbuser -Pdbpassword -deventdb -Q"fast_purge"
The
fast_purge file is stored in the same location as the other scripts
generated during database configuration (the default location is profile_root/databases/event/node/server/dbscripts/sqlserver).
The
parameters of this command are as follows:
- server_name
- The database server name.
- dbuser
- The database user ID to use when connecting to the event database.
- dbpassword
- The password to use for the specified user ID. This parameter
is optional; if you do not specify the password, the osql utility
prompts you for it.
- eventdb
- The name of the event database (typically event).