|
|
|
|
|
|
|
|
|
|
- Miscellaneous
- Necessary rights
<Connection variable>.InfoBackup (Función)
 Disponible solo con este tipo de conexión
Returns information about one or more backups performed on an HFSQL Client/Server server.
gcnxConnexion is Connection
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
Sintaxis
Información sobre las copias de seguridad realizadas en el servidor Ocultar los detalles
<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 - <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>: Variable de tipo Connection Name of the Connection variable that describes the connection to the server whose backups will be listed.
Información sobre una copia de seguridad específica Ocultar los detalles
<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>: Variable de tipo Connection 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 <Variable Connection>.Backup. Observaciones 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.
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|