Shrink Files
Description
This step shrinks a specific data file or log file in a SQL Server database. You provide the database name and the file to shrink along with the target size. Use this step in workflows that reclaim space from individual files, reduce oversized log files, or perform targeted file maintenance.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Name of the step. This name has to be unique in a single workflow. |
| Connection: | ||
| 2 | Server Name | The Hostname/Server Name/IP of the MSSQL Server. This field is mandatory. Drop down is available. |
| 3 | Instance name | The instance name of MSSQL Server instance. One of the two fields Instance name or Port is mandatory. Only variables/static values are allowed. |
| 4 | Port | The port number of the MSSQL server should be provided. If we provide Port number, there is no need to provide Instance name. Port number should only be an integer. |
| 5 | Username | A username of the MSSQL Server. This field is mandatory. |
| Password | ||
| 6 | Password | Specify or select the password, as required. If the checkbox Accept Value as variable/static is selected, then the password field appears as a text box and accepts static or variable values. OR If the checkbox Accept Value as variable/static is not selected, then the password field appears as a dropdown in which you can select a field from the previous steps. |
| 7 | Other Connection Parameter | Specify multiple, semi-colon separated parameters other than the default connection parameters. Other connection parameters will be appended to the default connection parameters. Example of default connection parameters: Server Name, Password. Examples of other connection parameters: encrypt=false;trustServerCertificate=false |
| Button | ||
| 8 | Test Connection | Verifies whether the connection is established or not. NOTE: Test Connection button does not work for previous step fields. Test Connection button only works with static values and environment variables. |
| Input Fields | ||
| 1 | Database | Name of the Database for which data or log file is to be shrinked. Field value is to be selected from the prompt by clicking on the Select database button. |
| 2 | Select database | Clicking on this button brings a dialog for the available databases on that particular SQL server instance. |
| 3 | File type | Type of the files to be deleted of a particular database i.e. Data files, Log files must be selected. |
| 4 | File name | Name of the file to be shrinked must be selected. Field value is to be selected from the prompt by clicking on the Select file button. |
| 5 | Select file | Clicking on this button brings a dialog for the available files of a particular database. |
| Output Fields | ||
| 1 | Result | Output field to hold the result of the successful plugin execution. This field is mandatory. For Error Handling: Refer Error Handling |