Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

How do you automate restoring a CaliberRM database and bypass the command line prompts?

How do you automate restoring a CaliberRM database and bypass the command line prompts?

Problem:

How do you automate restoring a CaliberRM database and bypass the command line prompts?

Resolution:


  • Product Name: CaliberRM
  • Product Version: All version
  • Product Component: Backup
  • Platform/OS Version: All


The standard syntax to restore a backup from the command prompt is:

vbackup -dev "C:\CaliberRM_Backup\SQMDB.bak" -restore SQMDB

During the restore process the user will answer the following prompts

During roll forward, would you like to apply records from the database"s current log file in addition to any archived records ? [default = yes ]

Would you like to do another level of restore on database "SQMDB"? [ default = no ]

The standard response to these prompts is no.

In order to automate a restore using a batch file there has to be some way of automating the response to the above prompts. The solution to this is to use an input file to simulate the input.

  1. Create a text file using Notepad with the following content, just two lines each with word "no"

    No
    No

  2. Save this file as c:\input.txt (this can actually be any location / folder).
  3. Create a batch file with following content
    vbackup -dev "C:\CaliberRM_Backup\SQMDB.bak" -restore SQMDB <>
  4. Execute the batch file

When the batch file is executed the responses for the two prompts will be taken from the input.txt file and the restore will complete as if you had supplied the answers from the keyboard.


Old KB# 15847

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 18:26
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.