sybrestore

sybrestore allows you to restore an SAP ASE database to the time of failure from the most current full database backup dump files.

Syntax

Parameters for interactive mode:

sybrestore [-v ] [-h ] 
	[-S server_name | host_name:port_number]
	[-t [point in time of restore]]
	[-d dump_directory]
	[-I interfaces_file ]
	[-J character_set ]
	[-P password ]
	[-U username]
	[-z language ]
    [-R  Restore from master database corruption ]
    [-s list system databases except master database ]
    [-o Log output]

Parameters for noninteractive mode:

sybrestore [-v ] [-h ]
	-S server_name | host_name:port_number
	-U username 
	[-P password]
	-D database_name
	[-d dump_directory]
	[-I interfaces_file]
    [-o Log output]

Parameters

-h – prints the help information and syntax usage and exits.
-D database_name – specifies the source database name.
-d dump_directory – specifies the dump directory for dumping the last log.
-I interfaces_file – identifies a specific interfaces file in which to look for server names. If you do not specify this parameter, sybrestore uses:
- (UNIX) $SYBASE/interfaces
- (Windows) %SYBASE%\ini\sql.ini
-J character_set – specifies the character set to be used for the SAP ASE connection.
-P password – specifies your SAP ASE password. If you do not specify the -P parameter, sybrestore prompts for a password.
-S server_name | host_name:port_number] – specifies the name of the source SAP ASE server. sybrestore looks for this name in the interfaces file.
host_name:port_number specifies the machine name and the port number.
-t point_in_time – restores the specified database to a point in time.
-U username – specifies a case-sensitive login name.
-v – prints the version string and exits.
-z language – specifies the language to be used for the SAP ASE connection.

Examples

command line mode – Invokes the command line interactive Restore Database menu. Use single-key entries to navigate through the menu options to specify options for restoring a database:
```
sybrestore -Usa -P -SlinuxData
```
```
sybrestore -Usa -P -SlinuxData

<<<<<<====User Database Restore Menu ====>>>>>>>>
c : Complete Database Restore
p : Database Point-In-Time Restore
```
To invoke the interactive command line Restore Database menu and execute the SQL statements for restoring the database to a point in time:
```
 sybrestore -Usa -P -SaseServer1 -t
```
Noninteractive mode – Invokes sybrestore in noninteractive mode using SAP ASE 15.7 ESD #2 and later. Executes the SQL statements for restoring the database and exits:
```
sybrestore -Usa -P -SaseServer1 -Ddba_db
```

Usage

Verify settings before using sybrestore.

SAP ASE server and Backup Server are running for both the target and source.
The master database is available.
The log segment of the source database is available for dumping and then loading back the most recent transaction logs that have not been dumped.
Either history files or external dump files are available.

Permissions

To use sybrestore, you must be logged in with the sa_role, or as the database owner.