<Connection variable>.InfoBackup (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions

Miscellaneous
Necessary rights

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Connection variable>.InfoBackup (Function)

In french: <Variable Connexion>.InfoSauvegarde

Available only with this kind of connection

Returns information about one or more backups performed on an HFSQL Client/Server server.

The backups have been performed by <Connection variable>.Backup (or via the HFSQL Control Center) and they can be restored by <Connection variable>.RestoreBackup (or via the HFSQL Control Center).

Example

// Description de la connexion
gcnxConnexion is Connection

// Affiche les informations sur les sauvegardes dans un champ Table
sEtat is string = gcnxConnexion.InfoSauvegarde()
sLig is string
FOR EACH STRING sLig OF sEtat SEPARATED BY EOT
	IF sLig ~="" THEN CONTINUE
	TABLE_Sauvegardes.Ajoute()
	nInd is int = TABLE_Sauvegardes.Occurrence()
	TABLE_Sauvegardes.COL_IDSauvegarde[nInd] = ExtractString(sLig, 1)
	TABLE_Sauvegardes.COL_DateHeure[nInd] = ExtractString(sLig, 2)
	TABLE_Sauvegardes.COL_Filtre[nInd] = ExtractString(sLig, 3)
	TABLE_Sauvegardes.COL_Nom[nInd] = ExtractString(sLig, 4)
	TABLE_Sauvegardes.COL_Description[nInd] = ExtractString(sLig, 5)
	TABLE_Sauvegardes.COL_Etat[nInd] = ...
			SWITCH(Val(ExtractString(sLig, 6)) + 1, "En cours", "Effectuée", "Annulée", "Erreur")
	TABLE_Sauvegardes.COL_PourMille[nInd] = ExtractString(sLig, 7)
END

Syntax

Information about the backups performed on the server Hide the details

<Result> = <Connection>.InfoBackup()

<Result>: Character string

Description of backups performed on the specified server. This description has the following format:
<Identifiant de la sauvegarde 1> + TAB + <Date de la sauvegarde 1> + TAB +
<Fichiers sauvegardés> + TAB + <Chemin de la destination de la sauvegarde 1> + TAB +
<Description> + TAB + <Etat> + TAB + <Pour mille> + TAB + <Message d'erreur> + TAB +
<Type> + TAB + <Nom du serveur> + TAB + <Identifiant de la sauvegarde complète> + TAB +
<Avec index> + TAB + <Compression> + EOT
where:
<Files saved> is the list of data saved separated by semicolons (";").
<Status> corresponds to an integer (or to an Integer constant) used to find out the backup status:
hBackupCanceled 2 Backup canceled
hBackupCompleted 1 Backup completed
hBackupError 3 Error during backup
hBackupInProgress 0 Backup in progress
<Per thousand> corresponds to the rate of backup completion if the backup is in progress (expressed in per thousand).
<Error Message> is the error message if the backup failed.
<Type> corresponds to an integer (or to an Integer constant) used to identify the type of backup:
hBackupDifferential 1 Differential backup
hBackupFull 0 Full backup
<Identifier of full backup> corresponds to the identifier of the corresponding full backup in case of differential backup.
<Nom du serveur> Backup server name.
<Avec index> To find out whether the backup contains:
0 if the backup of indexes was not performed,
1 if the backup of indexes was performed.
<Compression>: Constant corresponding to backup compression:
zipFormatAucun: the backup is not compressed.
zipFormatZip: the backup is compressed.
Note: the separator used between the different descriptions is "EOT" (and not "RC"), as the different description parameters may contain Carriage Returns (RC)..

<Connection>: Connection variable

Name of the Connection variable that describes the connection to the server whose backups will be listed.

Information about a specific backup Hide the details

<Result> = <Connection>.InfoBackup(<Backup identifier>)

<Result>: Character string

Description of specified backup on the specified server. This description has the following format:
<Identifiant de la sauvegarde 1> + TAB + <Date de la sauvegarde 1> + TAB +
<Fichiers sauvegardés> + TAB + <Chemin de la destination de la sauvegarde 1> + TAB +
<Description> + TAB + <Etat> + TAB + <Pour mille> + TAB + <Message d'erreur> + TAB +
<Type> + TAB + <Nom du serveur> + TAB + <Identifiant de la sauvegarde complète> + TAB + <Avec index> + TAB +
<Compression> + EOT

where:
<Files saved> is the list of data saved separated by semicolons (";").
<Status> corresponds to an integer (or to an Integer constant) used to find out the backup status:
hBackupCanceled 2 Backup canceled
hBackupCompleted 1 Backup completed
hBackupError 3 Error during backup
hBackupInProgress 0 Backup in progress
<Per thousand> corresponds to the rate of backup completion if the backup is in progress (expressed in per thousand).
<Error Message> is the error message if the backup failed.
<Type> corresponds to an integer (or to an Integer constant) used to identify the type of backup:
hBackupDifferential 1 Differential backup
hBackupFull 0 Full backup
<Identifier of full backup> corresponds to the identifier of the corresponding full backup in case of differential backup.
<Server name> Name of the backup server.
<Avec index> To find out whether the backup contains:
0 if the backup of indexes was not performed,
1 if the backup of indexes was performed.
<Compression>: Constant corresponding to backup compression:
zipFormatAucun: the backup is not compressed.
zipFormatZip: the backup is compressed.
Note: the separator used between the different descriptions is "EOT" (and not "RC"), as the different description parameters may contain Carriage Returns (RC)..

<Connection>: Connection variable

Name of the Connection variable that describes the connection to the server that performed the backup.

<Backup identifier>: Integer

Identifier of the backup for which to get the characteristics. This identifier is returned by <Connection variable>.Backup.

Remarks

Miscellaneous

<Connection variable>.InfoBackup is used to list the tasks performed or the current tasks. The scheduled tasks that have not been performed are not listed.
The backups performed by the HFSQL Control Center and the ones performed through programming are listed.
Dates and times are expressed in universal time (UTC).

Necessary rights

To get in formation about a backup, the user or the group must have:

for each database affected by the backup, the rights to perform backups (hRightsBackup constant) or the rights to connect (hRightsConnection or hRightsEncryptedConnection constant).
for a full server backup, the rights to perform backups (hRightsBackup constant) on the server.

To find out whether these rights are granted to a user or to a group, use <Connection variable>.InfoServerRights or <Connection variable>.InfoDatabaseRights.

To modify the rights granted to a user or group of users, use <Connection variable>.ModifyServerRights or <Connection variable>.ModifyDatabaseRights.

Component: wd300hf.dll