Template:SQWareProduction sqwmsq BackupAllDatabases.ksh help: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to 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_BackupAllDatabases.ksh [-h] -I <FreeTdsAlias> [+ options]
Run sqwmsq_BackupAllDatabases.ksh -h : 2024-12-24 08:36:35


DESCRIPTION
__________________________________________________________________
  sqwmsq_BackupAllDatabases.ksh backup all databases in parallel
Program informations
SUPPORT
SqwVersion=2024.08 / 2024.08
  MsSql supported versions: 2000 <= v <= 2022
2024-12-24 08:36:35
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_BackupAllDatabases.ksh -h
dbsqware@dbsqware02


PARAMETERS
sqwmsq_BackupAl,dbsqware ./sqwmsq_BackupAllDatabases.ksh -h
    -I  Instance      : Target instance (freeTds alias) to backup.
   `-pstree -aul 20722
OPTIONS
    -h                : Display the full usage.
    -s                : Display samples of usage.
    -P  Nb threads    : Number of threads in parallel (by default 4).
    -BP  path          : Path to put backup (by default: 'HKEY_LOCAL_MACHINE', 'BackupDirectory').
    -ID  listdb        : List of databases to include.
    -ED  listdb        : List of databases to exclude.
    -IL  likeclause    : Like clause to generate databases list (example: 'db%').
    -EL  likeclause    : Like clause to exclude databases (example: 'nodb%').
    -HI  Nb_Generations: Nb of generations to keep (by default 2).
    -WCD whereclause   : Where clause to generate databases list.
    -AllFull          : Select all databases with RECOVERY=FULL.
    -SMS SizeMax      : Size Max of backup stripe (by default 40000 Mo).
    -SBS SizeStat      : Display progression of backups (by default: Statisticss=10).
    -PAR parfile      : Parfile to use.
    -AGR Nb_sec        : Nb of seconds between two runs (by default 5s).
    -AGE Nb_sec        : Nb of seconds between two checks of end (by default 20s).
    -FRT return_code  : Force return code value on error.
    -REP              : Repeat of failed backups (overwrite all other options).
    -AddMail  email  : Email address to add at 'pmexpdba@gmail.com'.
    -ForceComp        : Force the compression of backup file (only for 2008 R2 standard edition).
    -PurgeDiff        : Delete all diff and log backups.
    -SendReport        : Send execution log report.
    -Type type        : Type of backup full,diff,log,CopyOnly (by default full).
    -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:35
End          : 2024-12-24 08:36:35
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_BackupAllDatabases.ksh -h : 2024-12-24 08:36:35

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

sqwmsq_BackupAl,dbsqware ./sqwmsq_BackupAllDatabases.ksh -h
  `-pstree -aul 20722

__________________________________________________________________


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

Begining     : 2024-12-24 08:36:35
End          : 2024-12-24 08:36:35
Duration     : 00:00:00