Template:SQWareProduction sqwmsq BackupDatabase.ksh help

From Wiki_dbSQWare
Revision as of 12:59, 11 January 2015 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Sourcing sqwmsq_Global.lib v3.1.06 SQWareProduction for MsSql (dbSQWare GPL v3) ... 

Usage: sqwmsq_BackupDatabase.ksh [-h] -S|-I <FreeTdsAlias> -D <DatabaseName> [+ options]

DESCRIPTION
   sqwmsq_BackupDatabase.ksh backup the database
SUPPORT
   MsSql supported versions: 2000 <= v <= 2012

PARAMETERS
     -S|-I  Instance    : Target instance (freeTds alias) for backup.
     -D  databasename   : Target database.
OPTIONS
     -h   help          : Display the full usage.
     -s                 : Display samples of usage.
     -BP  path          : Path to put backup (default: 'HKEY_LOCAL_MACHINE', 'BackupDirectory').
     -NS  Nb_stripe     : Force number of stripe.
     -HI  Nb_Generations: Number of generations to keep (by default 2).
     -FRT return_code   : Force return code value on error.
     -SMS SizeMax       : Size Max Stripe (default 40000 Mo).
     -SBS SizeStat      : Size of backup stats (default: Statisticss=10).
     -REP               : Insert into repeat file on error.
     -AddMail email     : Email Address to add at 'pmexpdba@gmail.com'.
     -SendReport        : Send execution log report.
     -Type type         : Type of backup full,diff,log,CopyOnly (defaut full).
     -NoMail            : Desactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -Exec              : Execute commands (default, display generated commands)