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!@#