...
This activity connects to a Microsoft SQL Host. The Output of this activity should be used as input for all Connection parameters used for activities placed under Microsoft SQL category.
NOTE: If during the execution of the workflow, the connection expires, the activity will attempt three times to automatically reconnect to Microsoft SQL host using the input credentials.
Activity Parameters
The Connect to MSSQL activity parameters can be provided by manual inserted values or via IN arguments or variables:
...
The Backup Database activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- Backup Path (text box editor type) (type: string): the full path where the backup file will be created.
- Media Name (text box editor type) (type: string): the new media a media name. For better results, use the same name as the database's. As an example, the Restore activity will work properly on a 2014 SQL Server when using the same name as the database's for the media set.
- Name (text box editor type) (type: string): the name of the backup set. Names can have a maximum of 128 characters. (E.g. 'Full Backup of Database'). In the example the name of the backup is the same as the database's.
- Timeout (text box editor) (type: Int32): the time in seconds to wait for the backup operation to execute. The default value in 30 seconds.
Execution: the activity will create a backup file of the database settled in the connection activity, in the specified folder:
...
The Restore Database activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- Backup File Path (text box editor type) (type: string): the path of the backup file or select it with the File Browser. The .bak file path can be manually written or selected by clicking the
button. In this example the backup file has the same name as the database's. - Timeout (text box editor) (type: Int32): the time in seconds to wait for the backup operation to execute. The default value in 30 seconds.
Run query
This activity runs a query on a SQL Server database.
...