|
|
| Ligne 1 : |
Ligne 1 : |
| <pre> | | <pre> |
| Sourcing sqwmsq_Global.lib v2024.07 SQWareProduction for MsSql (dbSQWare) ... | | Can't find if env is 'SqlCmd' or 'FreeTds' ! |
| | Sourcing sqwmsq_Global.lib v2024.08 SQWareProduction for MsSql (dbSQWare) ... |
|
| |
|
| #Standard (Locale) help for script sqwmsq_RestoreDatabase.ksh:
| | Run sqwmsq_RestoreDatabase.ksh -s : 2024-12-24 08:28:47 |
|
| |
|
| | __________________________________________________________________ |
| | Program informations |
| | SqwVersion=2024.08 / 2024.08 |
| | 2024-12-24 08:28:47 |
| | Copyright 2010-2024, dbSQWare (www.dbsqware.com) |
| | Linux dbsqware02 4.15.18-21-pve #1 SMP PVE 4.15.18-48 (Fri, 20 Sep 2019 11:28:30 +0200) x86_64 GNU/Linux |
| | gvsqw_GenPath=/home/dbsqware/dbSQWare/SQWareProduction/mssql/bin |
| | Path=/home/dbsqware/dbSQWare/SQWareProduction/mssql/bin |
| | ./sqwmsq_RestoreDatabase.ksh -s |
| | dbsqware@dbsqware02 |
|
| |
|
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -h
| | sqwmsq_RestoreD,dbsqware ./sqwmsq_RestoreDatabase.ksh -s |
| #Affichage de l'aide en ligne pour ce script
| | `-pstree -aul 5129 |
|
| |
|
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -Locale fr -h
| | __________________________________________________________________ |
| #Affichage de l'aide en ligne pour ce script avec forcage de la locale 'fr' (Locale par defaut geree par $gvsqw_Locale)
| |
|
| |
|
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -s
| |
| #Affichage des exemples d'utilisation pour ce script
| |
|
| |
|
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName>
| | Not sending mail because you are in connected mode !!! |
| #Genere les commandes mais ne les execute pas !
| | Error, ExecEnvType='LinuxKO' ... |
| | |
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName> -Exec
| |
| #Execute une restauration standard de la database cible
| |
| | |
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName> -DS <DatabaseSource> -After <script> -Exec
| |
| #Execute le script <script> puis restaure la database (par defaut, le meme que -DT)
| |
| | |
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName> -DD <date> -Before <script> -Exec
| |
| #Execute le script <script> puis restaure la database avec le backup du <date> (par defaut prend le dernier)
| |
| | |
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName> -BP <path> -Exec
| |
| #Chemin <path> des backups a restaurer (par defaut: 'HKEY_LOCAL_MACHINE', 'BackupDirectory')
| |
| | |
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName> -REP -Exec
| |
| #Retente les sauvegardes qui ont echoue (prend la main sur les autres options)
| |
| | |
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName> -Move -Exec
| |
| #Restaure les databases en deplacant l'emplacement des fichiers
| |
| | |
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName> -AfterSql <script> -Exec
| |
| #Execute un script sql une fois la restauration terminee
| |
| | |
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName> -BeforeSql <script> -Exec
| |
| #Execute un script sql avant la restauration
| |
| | |
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName> -AddMail 'mymail1@mydomaine.com,mymail2@mydomaine.com' -Exec
| |
| #Ajoute la liste de mail a l'adresse par defaut geree par $gvsqw_GlobalMail
| |
| | |
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName> -SendReport -Exec
| |
| #Envoie la log par mail a la fin du traitement meme s'il n'y a pas d'erreur (par defaut, seulement en cas d'erreur)
| |
| | |
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName> -Type <TypeRestore> -Exec
| |
| #Change le type de backup (full,diff)
| |
| | |
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName> -NoMail -Exec
| |
| #Desactive l'envoi de mail sur erreur a $gvsqw_GlobalMail (par defaut, seulement en cas d'erreur)
| |
| | |
| $gvsqw_MsqBin/sqwmsq_RestoreDatabase.ksh -I $Alias -DT <DbName> -FRT <NumericValue> -Exec
| |
| #Force le code retour a '<NumericValue>' sur erreur (si pas d'erreur, "exit 0"!)
| |
| #Vous pouvez aussi forcer le code retour de ce script pour tous
| |
| #si vous settez la variable d'environnement: $gvsqw_ForcedReturnCodeScript_sqwmsq_RestoreDatabase=<NumericValue>
| |
| #dans le fichier de configuration $gvsqw_MsqBin/../etc_cust/sqwmsq_GlobalVar.cfg
| |
|
| |
|
| | Begining : 2024-12-24 08:28:47 |
| | End : 2024-12-24 08:28:47 |
| | Duration : 00:00:00 |
| </pre> | | </pre> |
Can't find if env is 'SqlCmd' or 'FreeTds' !
Sourcing sqwmsq_Global.lib v2024.08 SQWareProduction for MsSql (dbSQWare) ...
Run sqwmsq_RestoreDatabase.ksh -s : 2024-12-24 08:28:47
__________________________________________________________________
Program informations
SqwVersion=2024.08 / 2024.08
2024-12-24 08:28:47
Copyright 2010-2024, dbSQWare (www.dbsqware.com)
Linux dbsqware02 4.15.18-21-pve #1 SMP PVE 4.15.18-48 (Fri, 20 Sep 2019 11:28:30 +0200) x86_64 GNU/Linux
gvsqw_GenPath=/home/dbsqware/dbSQWare/SQWareProduction/mssql/bin
Path=/home/dbsqware/dbSQWare/SQWareProduction/mssql/bin
./sqwmsq_RestoreDatabase.ksh -s
dbsqware@dbsqware02
sqwmsq_RestoreD,dbsqware ./sqwmsq_RestoreDatabase.ksh -s
`-pstree -aul 5129
__________________________________________________________________
Not sending mail because you are in connected mode !!!
Error, ExecEnvType='LinuxKO' ...
Begining : 2024-12-24 08:28:47
End : 2024-12-24 08:28:47
Duration : 00:00:00