› Output Manager › Server and database administration › Backing up and restoring the Output Manager database › Back up from a command prompt

Back up from a command prompt

Use this procedure to perform a backup from the Windows command prompt.

You can use the OmBackupDatabase.exe command line utility to manually backup an SQL database to a folder. You can enter parameters to limit the number of backup files that will be saved by deleting the oldest backups. The following table lists the available parameters. Executing the command without any parameters causes it to display usage information.

  1. Open a Windows command prompt windows.
  2. Enter the following command at the command prompt to perform a backup.
    • EOMBackupDatabase.exe - Database = database_name - optional_parameters
  3. After the database name, you can type any of the parameters listed in the following table. Separate parameters with a space.
    Parameter Description
    - Database = database_name Specifies the database. This parameter is required.
    - Server = SQLServer / instance Where SQLServer / instance is the instance name of SQL Server where the database is located. The default server is localhost\SqlExpress.

    The server name is required if SQL Server is installed on a different computer from where the backup is being performed and SQL Express is not being used.

    An instance name is not used for the default instance of SQL Server, but the instance name is required to specify a named instance of SQL Server. By default, SQL Express installs a named instance with the instance name of SQLEXPRESS.
    - Folder = backup_folder

    Where backup_folder is the path for the backup folder. If the location does not exist, the folder will be automatically created. File shares and any path containing spaces must be enclosed between quotation marks ("). If a backup folder is not specified, the backup file will be saved in the default path for the installation, for example C:\Program Files\Nuance\Output Manager\Database\Backup.

    The backup file will be saved with a unique file name using the database name, date, and time. This makes it easy to see when a backup was created.

    If you want to configure the software to automatically purge older backup files, always use the same backup folder. Using a folder on another computer will provide additional security that data will not be lost due to a disk failure at the cost of additional network usage

    - Keep = number

    Where number is the maximum number of backups to keep in the backup folder. After a backup is performed for a database, the backup files are sorted and the oldest files are deleted until the number of files to keep is reached. The default number of backup files to be kept is 30.

    To disable purging, specify Keep=0. This will retain all backup files.