Command Line Parameters

Owned by Nate Edwards
Jul 31, 2017

BATCH MODE

Database Utilities can be run from the command line using parameters. This is useful for putting commands into batch file or for executing functions on a schedule.

General notes

    • All commands are case-insensitive.
    • Whenever a file name is required, it is recommended to give the entire path enclosed in quotes, i.e. “c:\data\backup.bak”.
    • All commands will target the eshadata repository.

RUN SCRIPT

    • Format
      dbutil -script file
    • Parameters
      file: the location of the script to be executed.
    • Explanation
      This command loads and executes a file containing SQL commands. The file must contain a sequence of valid SQL commands. The entire file will be loaded, and then executed as a long sequence of commands.
    • Notes
      A comment in the file is indicated by “--”. Whenever these characters are found, the rest of that line will be ignored by the program. The use of the keyword “GO” between sets of operations is supported. Whenever “GO” is found, the program will execute all instructions read so far, and then begin reading commands again.

BACKUP DATABASE

    • Format
      dbutil -backup file
    • Parameters
      file: (optional) the database backup will be written to this file.
    • Explanation
      This command performs a backup on the entire eshadata database.
    • Notes
      The file parameter is optional; if it is not provided, the program will create a default name for the file, in the format Eshadata_date-time.bak. If the file named already exists, it will be deleted before the backup begins. The file named must physically reside on the same computer that contains the SQL Server instance. It cannot be a shared network drive.

RESTORE DATABASE

    • Format
      dbutil -restore file
    • Parameters
      file: the database backup file to be restored.
    • Explanation
      This command performs a restore of the eshadata database using the backup file named. The database will return to the previous state of the backup file, and all data entered since the backup was made will be lost forever.
    • Notes
      Unlike previous versions of the Database Utilities, there are no naming conventions required on the file.

SHRINK DATABASE

    • Format
      dbutil -shrink
    • Parameters
      None.
    • Explanation
      This command cleans up unused logs and compresses the database to improve performance and save disk space.
    • Notes
      None.