Backup All Databases
This script will backup all databases found in the configured instance.
Input Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| Server | String | No | Name of the server, this should be blank for the local server. |
| Instance | String | Yes | The name of SQL instance, use '(local)' for local unnamed instance. |
| User Name | String | No | Used for Sql Authentication, not required for Windows credentials. |
| Password | String | No | The password for SQL Authentication, not used for Windows credentials. |
Output Parameters
| Name | Type | Description |
|---|---|---|
| Result | Number | Returns a success value of zero or any value other than zero to indicate failure. |
Example Input Parameters
| Name | Type | Required | Example |
|---|---|---|---|
| Server | String | Yes | <intentionally left blank> |
| Instance | String | Yes | MSSQLSERVER |
| User Name | String | No | administrator |
| Password | String | No | Password!@# |