|
|
|
|
|
- Characteristics of backup:
- Rights required to add a scheduled backup
- Operations on a scheduled backup
<Connection variable>.AddScheduledBackup (Function) In french: <Variable Connexion>.AjouteSauvegardePlanifiée
Available only with this kind of connection
Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection. This backup scheduling was defined by an hBackupDescription variable.
DatabaseConnection is Connection
...
hBck is hBackupDescription
hBck.Enabled = True
hBck.WithIndex = True
hBck.Description = "Scheduled backup every N minutes with " + ...
"an incremental backup every minut on the " + ...
DBConnection.Database + " created on "+ ...
DateToString(DateSys(), maskDateSystem) + " at "+ ...
TimeToString(TimeSys(), "HH:MM:SS:CC")
hBck.Destination = "Backup_" + DBConnection.Database
hBck.LimitNumberBackups = 2
hBck.Source = DatabaseConnection.Database
hBck.SchedulingFull.Month = "*"
hBck.SchedulingFull.DayOfMonth = "*"
dhServerDateTime is DateTime = DBConnection.InfoServer(hInfoDate)
dtServerDateTime.Minute++
hBck.SchedulingFull.Hour = dtServerDateTime.Hour
hBck.SchedulingFull.Minute = dtServerDateTime.Minute
hBck.SchedulingFull.DayOfWeek = "*"
hBck.SchedulingFull.DayOfMonthOrDayOfWeek = False
hBck.SchedulingDifferential.Month = "*"
hBck.SchedulingDifferential.DayOfMonth = "*"
hBck.SchedulingDifferential.Hour = "*"
hBck.SchedulingDifferential.Minute = "*"
hBck.SchedulingDifferential.DayOfWeek = "*"
hBck.SchedulingDifferential.DayOfMonthOrDayOfWeek = False
IF DBConnection.AddScheduledBackup(hBck) = False THEN
Error("Failure creating the scheduled backup", ...
HErrorInfo(hErrFullDetails))
RETURN
END
Syntax
<Result> = <Connection>.AddScheduledBackup(<Scheduled backup>)
<Result>: Boolean - True if the scheduled backup was added,
- False otherwise.
<Connection>: Connection variable Name of the Connection variable that describes the connection for which a scheduled backup must be added. <Scheduled backup>: hBackupDescription variable Name of the hBackupDescription variable used. Remarks Characteristics of backup: - Backup the contents of an HFSQL server: all server databases, several or a single database, one or more data files. This backup can be performed even if one or more databases are currently used.
- The backup performed will correspond to the state of the database at the start of the backup: the backed-up database is consistent.. Certain operations are prohibited during backup: deleting files and databases, updating stored procedures.
- The backup description is performed via the hBackupDescription variable. You can define:
- a stored procedure to run BEFORE the backup. This procedure can cancel the backup if necessary.
- a stored procedure to run AFTER the backup.
Rights required to add a scheduled backup To add a scheduled backup, the user or user group must have: - the rights to perform backups (hRightsBackup constant). These rights apply to the servers and to the databases. For example, to perform a full server backup, you must have the rights to perform backups at server level.
- the rights to manage the tasks (hRightsManageTask constant).
Operations on a scheduled backup Several functions are used to handle a scheduled backup: You can also:
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|