Difference between revisions of "Template:SQWareProduction sqwmsq RestoreDatabase.ksh help"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 1: Line 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) ...  
  
−
Usage: sqwmsq_RestoreDatabase.ksh [-h] -I <FreeTdsAlias> -DT <DatabaseName> [+ options]
+
Run sqwmsq_RestoreDatabase.ksh -h : 2024-12-24 08:36:38
  
−
DESCRIPTION
+
__________________________________________________________________
−
  sqwmsq_RestoreDatabase.ksh restore database
+
Program informations
−
SUPPORT
+
SqwVersion=2024.08 / 2024.08
−
  MsSql supported versions: 2000 <= v <= 2022
+
2024-12-24 08:36:38
 +
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 -h
 +
dbsqware@dbsqware02
  
−
PARAMETERS
+
sqwmsq_RestoreD,dbsqware ./sqwmsq_RestoreDatabase.ksh -h
−
    -I  Instance      : Target instance (freeTds alias).
+
   `-pstree -aul 22910
−
    -DT TargetDatabase : Target database to Load.
 
−
OPTIONS
 
−
    -h                 : Display the full usage.
 
−
    -s                : Display samples of usage.
 
−
    -F  filename      : Backup file to Load ((by default take the latest).
 
−
    -BP  path          : Path to find backup to Load (by default: 'HKEY_LOCAL_MACHINE', 'BackupDirectory').
 
−
    -DS  DatabaseSource: Database source (by default same than -DT).
 
−
    -DD  date          : Date of Dump (by default take the latest).
 
−
    -FRT return_code  : Force return code value on error.
 
−
    -REP              : Insert into repeat file on error.
 
−
    -Move              : Generate move instruction.
 
−
    -Type  type      : Type of restore full,diff (by default full).
 
−
    -Before    script  : Script to execute before restore.
 
−
    -After    script  : Script to execute after restore.
 
−
    -BeforeSql script  : Sql script to execute before restore.
 
−
    -AfterSql  script  : Sql script to execute after restore.
 
−
    -AddMail   email  : Email address to add at 'pmexpdba@gmail.com'.
 
−
    -SendReport        : Send execution log report.
 
−
    -NoMail            : Deactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
 
−
    -Locale    locale  : Force Locale for help display (fr,en).
 
−
    -Exec              : Execute commands (by default, display generated commands).
 
  
 +
__________________________________________________________________
 +
 +
 +
Not sending mail because you are in connected mode !!!
 +
Error, ExecEnvType='LinuxKO' ...
 +
 +
Begining    : 2024-12-24 08:36:38
 +
End          : 2024-12-24 08:36:38
 +
Duration    : 00:00:00
 
</pre>
 
</pre>

Revision as of 09:37, 24 December 2024

Can't find if env is 'SqlCmd' or 'FreeTds' !
Sourcing sqwmsq_Global.lib v2024.08 SQWareProduction for MsSql (dbSQWare) ... 

Run sqwmsq_RestoreDatabase.ksh -h : 2024-12-24 08:36:38

__________________________________________________________________
Program informations
SqwVersion=2024.08 / 2024.08
2024-12-24 08:36:38
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 -h
dbsqware@dbsqware02

sqwmsq_RestoreD,dbsqware ./sqwmsq_RestoreDatabase.ksh -h
  `-pstree -aul 22910

__________________________________________________________________


Not sending mail because you are in connected mode !!!
Error, ExecEnvType='LinuxKO' ...

Begining     : 2024-12-24 08:36:38
End          : 2024-12-24 08:36:38
Duration     : 00:00:00
Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwmsq_RestoreDatabase.ksh_help&oldid=29872"