Restoring a Database Using sybrestore

Use sybrestore, which supports Adaptive Server versions 15.7 ESD #2 and later, to restore an Adaptive Server database to the time of failure from the most current full database backup dump files.

In Adaptive Server versions 15.7 SP100 and later, sybrestore also supports restoring from Tivoli Support Manager and cumulative dumps, as well as applying database attributes via sp_dboption when a database is re-created and restored from the dump file.

sybrestore offers two modes—interactive and noninteractive—and is supported on both Windows and UNIX platforms.

• Noninteractive Mode
  Providing the database name invokes the utility in noninteractive mode, which restores a database using the most current dump history files.
• Interactive Mode
  In interactive mode, you can specify:
• Before You Begin
  Perform these tasks before using sybrestore.
• Using sybrestore
  sybrestore performs checks in both interactive and noninteractive modes:
• Restoring a Database in Noninteractive Mode
  In Adaptive Server 15.7 ESD #2 and later, use sybrestore in noninteractive mode to restore a database to the time of failure from the most current dump history files.
• Restoring a Database in Interactive Mode
  The interactive command line interface allows single-key entry, plus the Enter key to navigate through each menu. Use: