Backup All Databases
This Automation Manager object will backup all databases found in the configured instance.
Input Parameters
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
Result |
Number |
Returns a success value of zero or any value other than zero to indicate failure. |
Example Input Parameters
Server |
String |
Yes |
<intentionally left blank> |
Instance |
String |
Yes |
MSSQLSERVER |
User Name |
String |
No |
administrator |
Password |
String |
No |
Password!@# |