11.7 DumpTran

Use this Action Knowledge Script with selected SQL Knowledge Scripts (such as DataSpace, DBSpace, and LogSpace) to dump the transaction log of a database when an event is raised. For example, if the DBSpace Knowledge Script detects that the database space available has fallen below the threshold, you can use this Action to automatically dump the transaction log to free up space. Syntax and permission checking is handled by SQL Server.

When configuring this action, keep in mind:

The Action can run only on the managed computer as a Managed Client Action. Be sure to select MC (Managed Client) as the Location on the Action tab of the Properties dialog box.
This script requires an account with System Administrator privileges or dbo privileges to run. If you run this Action on SQL Server 7, the Dump Transaction can be done by a dbo or db_backup operator account. For more information about the permissions required for a Dump Transaction command, see your SQL Server documentation.
This script requires a database name supplied by the SQL Knowledge Script to perform the dump. If the Knowledge Script that raises the event is running with the Dynamically observe databases at each interval? parameter enabled (so that it dynamically discovers database names at run time), the Action will fail. To use this Action, disable the Dynamically observe databases at each interval? parameter in the DataSpace, DBSpace, or LogSpace Knowledge Script.

This Action can only operate on a database whose recovery model is either Full or Bulk-Logged.

11.7.1 Setting Parameter Values

Set the following parameters as needed:

Parameter	How to Set It
SQL login	Specify the database user account used to run this Knowledge Script, for example, sa. You can run this Knowledge Script using other user accounts that have been set up in the SQL Server of the managed client and have been given permission to run SQL Knowledge Scripts through the AppManager Security Manager.
Truncate only?	Set to y to truncate the transaction log, without saving the truncated information to any location. If set to n, you must specify where the transaction log should be sent in the TO statement parameter. The default is n.
TO statement	If Truncate only? is disabled, enter a TO statement to specify where the truncated transaction log should be sent. The default is to diskdump.

Parameter

How to Set It

SQL login

Specify the database user account used to run this Knowledge Script, for example, sa.

You can run this Knowledge Script using other user accounts that have been set up in the SQL Server of the managed client and have been given permission to run SQL Knowledge Scripts through the AppManager Security Manager.

Truncate only?

Set to y to truncate the transaction log, without saving the truncated information to any location. If set to n, you must specify where the transaction log should be sent in the TO statement parameter. The default is n.

TO statement

If Truncate only? is disabled, enter a TO statement to specify where the truncated transaction log should be sent. The default is to diskdump.