SqlUtilBackupDatabaseToDisk - cDbUpdateFunctionLibrary

Backs up an SQL database. Either to a particular disk folder or to the default SQL backup folder.

Type: Function

Parameters: String sDatabase String sBackupName String sPath

Parameter	Description
sDatabase	The name of the SQL database
sBackUpName	The name of the backup file name.
sPath	The path to the folder to backup to. If left empty the default SQL backup folder will be used.
bShowProgress	Optional. If the backup progress should be shown or not. If the ghoStatusPanel is active - the info will be shown there. Else Showln is used to display the progress percentage.

Syntax

Procedure SqlUtilBackupDatabaseToDisk String sDatabase String sBackupName String sPath Boolean bShowProgress

Call:

Send SqlUtilBackupDatabaseToDisk "OrderEntry" "OrderEntry" "T:\Backups\SQLBackups" False

Description

Uses embedded SQL (ESQL) script code to backup the specified SQL database. This can be performed while the database is in use. The fourth parameter is optional.

Note: Currently only available for the Microsoft SQL Server database, but could be improved with SQL script files for other back-ends.