Reference Manual
   CHAPTER 9. SQL Statements     

RESTORE statement

Function 

Restore a backed up database from an archive.

Syntax 

RESTORE DATABASE database_location
FROM archive_root
[ [ RENAME dbspace_name TO new_dbspace_path ] ...]

Permissions 

Must be connected to the utility database.

Side effects 

None.

See also 

BACKUP statement

Description 

database_location     Specifies the location for the main database file.

Each RESTORE operation updates a history file called backup.syb, which is held in the same directory as your database server executable file.

Archive backups are only supported on NT and Unix platforms.

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Not supported in Adaptive Server Enterprise.