Template:SQWareProduction sqwmsq RestoreDatabase.ksh help

From Wiki_dbSQWare
Revision as of 18:54, 23 February 2018 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 v4.0.03 SQWareProduction for MsSql (dbSQWare) ... 

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

DESCRIPTION
   sqwmsq_RestoreDatabase.ksh restore database
SUPPORT
   MsSql supported versions: 2000 <= v <= 2012

PARAMETERS
     -S|-I  Instance    : Target instance (freeTds alias).
     -DT TargetDatabase : Target database to Load.
OPTIONS
     -h   help          : 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 (default: 'HKEY_LOCAL_MACHINE', 'BackupDirectory').
     -DS  DatabaseSource: Database source (by default same than -DT).
     -BD  bck_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 (defaut full).
     -Before script     : Script to execute before restore.
     -After  script     : Script to execute after restore.
     -AddMail email     : Email Address to add at 'pmexpdba@gmail.com'.
     -SendReport        : Send execution log report.
     -NoMail            : Desactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -Exec              : Execute commands (default, display generated commands)