sybrestore

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

Syntax

sybrestore [-v ] [-h ] 
	[-S server_name | host_name:port_number]
	[-t  restore database to point in time]
	[-D database_name ]
	[-d dump_directory]
	[-I interfaces_file ]
	[-J character_set ]
	[-P password ]
	[-U username]
	[-z language ]

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 Adaptive Server connection.
-P password – specifies your Adaptive Server 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 Adaptive 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 Adaptive Server 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

<<<<<<<<<====Restore Database Menu ====>>>>>>>>
s : Select Database
t : Target Server
r : Recreate Database
e : Use External Dump
c : Check Geometry
d : Dump Directory
o : Online Database
p : Preview 
g : Go
```
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 Adaptive Server 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.

Adaptive 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.