Backup All Databases
This script 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!@# |
