SmartBackup (SQL Server only)

[path]SmartBackup SqlServer=<sqlServerName> DatabaseName=<databaseName> User=<userName> Password=<password> RetainDays=<numberOfDays>

Example

This example uses SmartBackup to create a backup of the SmartBatch database on SQL Server NY.  The backup will be retained for 30 days.

c:\ProgramFiles\SmartBatch\bin\SmartBackup.exe sqlServer=NY databaseName=SmartBatch user=sa password=sa retainDays=30

[path]

SmartBackup is a program that is installed when you install SmartBatch. You need to specify the full path to the program to run it successfully or have it in your search path. For example:

c:\Program Files\SmartBatch\bin\SmartBackup.exe

You can set a search path for executable files using environmental variables. Refer to Windows documentation for information about paths and environmental variables.

SqlServer

Indicates the name of the SQL Server to use for the backup.

Database Name

The name of the database for the backup.

User

The SQL Server user to use to connect to the SQL Server.

Password

The password associated with the user to use when connecting to the SQL Server.

RetainDays

The number of days to retain the backup.